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