How do you ignore ';' as a delimiter in the <sql> tag when creating stored procedures?
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Joyce_Wang
Posted On:   Saturday, November 3, 2001 07:02 PM

I'm using the tag to call a sql script (Oracle), but there are semicolons within
the statement I use to create a stored procedure. I guess ant tries to execute
these statements and spews an error:


[sql] Failed to execute: Pupdate_count := SQL%ROWCOUNT


I'd rather not modify the sql script to use different delimiters,
since the script is also being used outside of ant.


Is there any way not to execute statements ending in a semicolon
when it appears within a stored procedure creation statement?

Re: How do you ignore ';' as a delimiter in the <sql> tag when creating stored procedures?

Posted By:   Erik_Hatcher  
Posted On:   Sunday, November 4, 2001 03:59 PM

I don't know the answer to this question, but wanted to find out what version of Ant you are using. I know improvements have been made to this task lately, so I'd recommend trying with Ant 1.4.1 if you aren't already. Also, there is a 'delimiter' attribute that could likely help this situation.
About | Sitemap | Contact