This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » This Site » Ranch Office
Reply locked New topic
Author

problem in running stored procedure through ant script

Satish Jhaldiyal
Greenhorn

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
author
Rancher

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

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.

Eric
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in running stored procedure through ant script
 
Similar Threads
JDBC connection to sql server
problem in running stored procedure through ant script
Problem using Callable Statement
Stored procedure call removes spaces in text
Servlets and PL\SQL