Invoke external PL/SQL procedure

, ,
1

Hi,

Anyone knows how to invoke Oracle PL/SQL procedure using webMethods?

Please advise.

my email :sabri@perodua.com.my

2

Hi,
To invoke Oracle PL/SQL procedure do the following in webMethods:

  1. Configure the Oracle Adapter, and connect it to the database.
  2. Configure an operation on the adapter and select “Stored Procedure Call” from the operation template.
  3. Select the “User Name” and the “Procedure Name” in the Call tab of the operation. Note that the user should have enough priveleges to call the procedure.

Success.
Archana