I have a requirement where in i need to run sql files through ant. All was fine until i found out that ANT treat PL/SQL(stored procedures,functions,triggers etal) differently and simple queries other way. My problem is that my sql file contains both and this is causing me a problem cos to run Stored Procedure I use delimiter="//" in my ant task, which makes normal sql task to fail and vice versa. I have tried many things but nothing worked in my favor. Any help would be appreciated.
This forum is intended for questions and comments about the web sites www.javaranch.com and www.coderanch.com.
It is not for questions about the Java language - that's what all our other forums are for.
I am closing this thread. Please repost your question in the right portion of the forum.
subject: problem in running stored procedure through ant script