DSXchange

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...

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)