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

  • 1.  Invoke Oracle PLSQL procedure or SQL file using webmethods

    Posted Mon May 26, 2003 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 Tue May 27, 2003 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 Tue May 27, 2003 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


Related Content