ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Woehr <>
Subject Re: Ant SQL Task can define stored procedure?
Date Fri, 02 Apr 2004 22:00:33 GMT
"Anderson, Rob (Global Trade)" wrote:

> Check out keepformat attribute of the sql task.

I am already using that one, thanks!

> Also, the escapeprocessing attribute may need to be set.

Ah, didn't catch that one.

> I found these two attributes to be necessary when loading packages and procedures into
a database with ant. If you are running serveral sql statements and loading a procedure, all
via a single sql file, you might need to specify delimeter="row" and organize your statements
and procedure in the file accordingly.

Thanks for the tips ...

Incidentally,  REM comments don't seem to work within the stored procedure even with keepformat

Jack J. Woehr            # "[F]ar in the empty sky a solitary esophagus slept #  upon motionless wing; everywhere brooded stillness, #  serenity, and the peace of God." - Mark Twain

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message