Calling PL/SQL procedures in Oracle from DataStage
Posted: Tue Apr 13, 2004 10:02 am
1) Can PL/SQL procedures on Oracle Database (that have a return value) be called from DataStage ? Would I need an ODBC driver ?
2) If the answer to Question 1 is "NO", can I make a call to a ProC function which in turn calls the PL/SQL procedures ?
3) Are there alternative solutions ?
Would appreciate if you can give an elaborate reply.
2) If the answer to Question 1 is "NO", can I make a call to a ProC function which in turn calls the PL/SQL procedures ?
3) Are there alternative solutions ?
Would appreciate if you can give an elaborate reply.