Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

ANT SQL TASK query + procedure question

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • 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
  • 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





 
Do you want ants? Because that's how you get ants. And a tiny ads:
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
    Bookmark Topic Watch Topic
  • New Topic