ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 30760] - sql task handle pl/sql with ';' in pl/sql code. (patch)
Date Mon, 23 Aug 2004 14:59:42 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30760>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30760

sql task handle pl/sql with ';' in pl/sql code. (patch)





------- Additional Comments From j_a_fernandez@yahoo.com  2004-08-23 14:59 -------
Usually PL/SQL code uses the "//" at begining of line to separate
sql statements that must be processed in separate commits, but there
is no restriction on pl/sql to have more than one DDL statement sent at once
AFAIR (I may be wrong).

With this in mind, have you tried just giving your file with delimeter="//" 
delimetertype="row" (check attribute names) and see what the Oracle JDBC driver
will do?

On the other hand, as every generation tool may do their particular quirks on 
the generated code, I see no reason why you could not have a step in your 
building process where the generatedfiles are preprocessed to produce 
something more friendly to a generic <sql/> task. 

I do not see why the <sql/> task needs to be maintained (and BC verified) 
against the whims of every generation tool that there is around.

Alternatively you could subclass. Sql.java and have your own version 
specialized for your tools and maintained by you (as oppose to us).
This is my main problem, who is goin to maintain all this special behaviors.

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


Mime
View raw message