Page 1 of 1
How to call a stored proc from OCI stage
Posted: Tue Jun 10, 2008 10:11 am
by datisaq
Can we call a stored proc from oracle OCI stage?
If it's then pls tell me clearly since i'm new to Datastage.
I heard we can call from Oracle EE in parallel edition.
Pls help me out...
Posted: Tue Jun 10, 2008 11:22 am
by lstsaur
Yes, from OCI stage's Before box, issue "call stp.name();".
Posted: Tue Jun 10, 2008 11:44 am
by paddu
You can call stored procedure in before or after sql TAB in OCI stage .
CALL STPName(Input paramters if you have any);
COMMIT
Probably need a COMMIT if you do not have a implicit commit in stored procedure.
Posted: Tue Jun 10, 2008 9:19 pm
by datisaq
Thanks for the help i'll try it...
Posted: Wed Jun 11, 2008 10:19 am
by datisaq
Thanks again, i'm able to call from OCI..
One clarification i need it, performance wise which is the best method of calling a script through script or call from the OCI stage since the proc which we call will inturn call some other 20 procs in it..
Which is the best suitable method?
Pls help me...