Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in running stored procedure through ant script

 
Satish Jhaldiyal
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic