File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Ranch Office and the fly likes problem in running stored procedure through ant script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » This Site » Ranch Office
Reply locked New topic

problem in running stored procedure through ant script

Satish Jhaldiyal

Joined: Dec 30, 2008
Posts: 8
Dear All,

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.

Its all in mind.
Eric Pascarello

Joined: Nov 08, 2001
Posts: 15385
On the top of this section of the forum it reads:

This forum is intended for questions and comments about the web sites and
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.

I agree. Here's the link:
subject: problem in running stored procedure through ant script
It's not a secret anymore!