Using the DataStage 7.5 OracleStored Procedure stage

sathyanveshi · Post by **sathyanveshi** » Tue Apr 19, 2005 10:31 pm

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

lstsaur · Post by **lstsaur** » Wed Apr 20, 2005 12:22 am

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.

sathyanveshi · Post by **sathyanveshi** » Wed Apr 20, 2005 12:42 am

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

roy · Post by **roy** » Wed Apr 20, 2005 1:43 am

Hi,
I guess your provider should be more then willing to send you hte relevant docs, just contact them