How to call a stored proc from OCI stage

datisaq · Post by **datisaq** » Tue Jun 10, 2008 10:11 am

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

lstsaur · Post by **lstsaur** » Tue Jun 10, 2008 11:22 am

Yes, from OCI stage's Before box, issue "call stp.name();".

paddu · Post by **paddu** » Tue Jun 10, 2008 11:44 am

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.

datisaq · Post by **datisaq** » Tue Jun 10, 2008 9:19 pm

Thanks for the help i'll try it...

datisaq · Post by **datisaq** » Wed Jun 11, 2008 10:19 am

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