ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anderson, Rob (Global Trade)" <Rob.Ander...@nike.com>
Subject RE: Ant SQL Task can define stored procedure?
Date Fri, 02 Apr 2004 22:31:37 GMT
> -----Original Message-----
> From: jax@purematrix.com [mailto:jax@purematrix.com]
> Sent: Friday, April 02, 2004 2:01 PM
> To: Ant Users List
> Subject: Re: Ant SQL Task can define stored procedure?
> 
> 
> "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 ...

With keepformat="true" I think it is up to your database to decide what is or isn't a comment.

-Rob Anderson 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message