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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
