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 18:12:55 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 18:12 -------

Are stored procedures part of a SQL9x standard? They are not in SQL 92 and as 
I remember Oracle PL/SQL procedures are not exactly what the newer SQL specs 
defined. I already think we have way too many stuff which is server specific 
hardcoded on this beast like "REM" (for MSSQL) for example. 

I look at your code and I am not sure whether it will play well with every 
other JDBC out there which may or may not support X,Y or Z. What is some allow 
for multiline strings? 

I wish we could define some new sql task with pluggability in mind so that 
each manufacturer could provide an ANT module (as part of the JDBC driver jar) 
that would do the syntactic checks required for that particular driver. 

So that the task just needs to identify the driver and delegate all this 
parsing issues. Then we could modularly and separately test all this stuff and
encourage manufactures to provide certified versions of the plug-in.

It would make this big monster into something manageable and neat.

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


Mime
View raw message