Invoking oracle stored procedure from DataStage
Posted: Tue Jul 24, 2001 12:16 pm
Hi,
I am trying to call an Oracle stored procedure from DataStage using the ODBC stage which apparently supports this. However, I am unable to get it working. If someone has got this to work, can you please explain the steps in detail? I am trying to call a simple Oracle procedure which has just one output parameter of type NUMBER. If there are any other ways to get this to work (OCI stage or something else), please let me know.
Thanks in advance,
Derick
_________________________________________________________
For Rs. 20,00,000 worth of Aptech scholarships click below http://events.rediff.com/aptechsch/scholarship.htm
I am trying to call an Oracle stored procedure from DataStage using the ODBC stage which apparently supports this. However, I am unable to get it working. If someone has got this to work, can you please explain the steps in detail? I am trying to call a simple Oracle procedure which has just one output parameter of type NUMBER. If there are any other ways to get this to work (OCI stage or something else), please let me know.
Thanks in advance,
Derick
_________________________________________________________
For Rs. 20,00,000 worth of Aptech scholarships click below http://events.rediff.com/aptechsch/scholarship.htm