Invoke external PL/SQL procedure

sabri.42186 · May 26, 2003, 4:11am

Hi,

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

Please advise.

my email :sabri@perodua.com.my

archana.sharma.33412 · May 27, 2003, 7:27am

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

Configure the Oracle Adapter, and connect it to the database.
Configure an operation on the adapter and select “Stored Procedure Call” from the operation template.
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