This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund 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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes 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: 15357
    
    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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: problem in running stored procedure through ant script
 
Similar Threads
JDBC connection to sql server
Stored procedure call removes spaces in text
Servlets and PL\SQL
problem in running stored procedure through ant script
Problem using Callable Statement