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-24 11:40 ------- OK, took a look at what actually your example here says and I am even more horrified than before 8-O Aparently in POSTGRESSQL an stored procedure is of the form: "CREATE" ... "AS" <multi-line-string> ";" This is extremely POSTGRESS specific, it seems like. Certaintly it does not match SQL99 spec which is the one standarizing PSMs (i.e., stored procedures). The truth is that as with any other programming language, there is no unique separator in SQL99, you need to understand the grammar of the language to know when things end due to the presence of nested statements. What the current <sql/> does is a complete hack. I may be willing to accept that <sql/> should be able ignore the ending char when inside a SQL string, which is the fundamental of what you provide. But we need to think not only on '....' SQL strings, but maybe also on "....." SQL table names, for example. Notice that this does not mean that this will solve any of the issues you were pretending to solve (i.e., a CREATE statement in SQL99 can have multiple ";"s outside strings). But it may just happen to be enough for POSGRESS. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
