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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  Invoke external PL/SQL procedure

    Posted 05/26/03 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 05/27/03 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