Page 1 of 1

Using the DataStage 7.5 OracleStored Procedure stage

Posted: Tue Apr 19, 2005 10:31 pm
by sathyanveshi
Hello,

I haven't worked on DataStage 7.5.But I heard that in DS 7.5 Oracle Stored Procedures can be used using a OCI stage.

May I know how it works?

Cheers,
Mohan

Posted: Wed Apr 20, 2005 12:22 am
by lstsaur
Hi Mohan,
Please read the STPstage.pdf documentation in the Docs folder. Beware of both examples of PL/SQL stored procedures, SSP21 and SSP3, given in the documentation are incorrect. However, if you know how to code PL/SQL stored procedure; you will figure out the code easiely. Have fun.

Posted: Wed Apr 20, 2005 12:42 am
by sathyanveshi
Hi,

I do not have the pdf with me nor do I ahve the DSEE 7.5. Can you please send the document to mohan.suswaram@wipro.com?

Cheers,
Mohan

Posted: Wed Apr 20, 2005 1:43 am
by roy
Hi,
I guess your provider should be more then willing to send you hte relevant docs, just contact them :)