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
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.
posted 3 years ago
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: