Invoke Oracle PLSQL procedure or SQL file using webmethods

, ,
1

Hello,

Anyone knows how to invoke PL/SQL procedure or SQL file using webMethods. That file can be in IS server it self or others server.

Please Advise

Regards

2

Hi Sabria,
you can use pub.db:call Java Service which is present in wmDB Package for executing the PL/SQL procedure on webMethods.

3

Hi Sabri,
As Atul said, you can use either pub.db:call or pub.db:execSQL for invoking stored procedures in Oracle. The stored procedure can be in the oracle database too.
Thanks