Calling PL/SQL procedures in Oracle from DataStage

[Inquisitive]

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.

[ogmios]

Maybe this helps:

viewtopic.php?t=86347

Ogmios