Hi All,
Is there any option like before/after sql( in oracle connector in 8.x)...in 7.x...
I want to execute 4 stored procedures with out loosing login session in oracle..
Thank you...
before/after sql option...
Moderators: chulett, rschirm, roy
before/after sql option...
Last edited by allavivek on Fri Aug 06, 2010 5:16 am, edited 1 time in total.
Re: before/after sql option...
I guess, you are trying to get some SQL session information for the current job session by using the beforeSQL/AfterSQL. I doubt that you will get hold of the same session since the beforeSQL/AfterSQL will be another process as such.
If you still want to, you may have write a shell script which triggers the stored procedures. You can call the script from the job's Beforejob/Afterjob subroutine (in Job properties section)
If you still want to, you may have write a shell script which triggers the stored procedures. You can call the script from the job's Beforejob/Afterjob subroutine (in Job properties section)