Invoke Oracle PLSQL procedure or SQL file using webmethods


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


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

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.