IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Invoke external PL/SQL procedure

  • 1.  Invoke external PL/SQL procedure

    Posted Mon May 26, 2003 12:11 AM

    Hi,

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

    Please advise.

    my email :sabri@perodua.com.my


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 2.  RE: Invoke external PL/SQL procedure

    Posted Tue May 27, 2003 03:27 AM

    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


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


Related Content