This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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


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: 15385
    
    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
 
It's not a secret anymore!