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 Oracle PLSQL procedure or SQL file using webmethods

    Posted 05/26/03 09:23 AM

    Hello,

    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

    Regards


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 2.  RE: Invoke Oracle PLSQL procedure or SQL file using webmethods

    Posted 05/27/03 09:03 AM

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


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 3.  RE: Invoke Oracle PLSQL procedure or SQL file using webmethods

    Posted 05/27/03 12:31 PM

    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.
    Thanks


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods