• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

ANT SQL TASK query + procedure question

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi All, first of all sorry if this is not the rigth place to ask, I did try some google before and tried a few things but could not find a solution just yet.

Any help is welcomed. here goes my problem.

I want to use a simple SQL task.
I execute several SQL queries in my ANT targets and most of them are ok. the point is that for one of them I have to execute a statment before so I can access the data that is protected.

this is what I want to do:



this is my script:


this is my output in ant


this is my output in toad


I know the problem is related to the set serveroutput on but i don't know how to go around it.

in the beggining my target was much easier, and output results but i cannot seem to go around the execution of the procedure in that same session.

this is what I had and the result


and output


the problem is related to that view and the fact that i need to execute the procedure before.

I also tried using different transactions insde one SQL target but didn't work much better.
 
Miguel Costa
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
just as FYI this was my first try before but that does not even work, not sure why because in the documentation it seems it should work:






Ant documentation





 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic