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

Invoking Oracle function [using WmDB package]

  • 1.  Invoking Oracle function [using WmDB package]

    Posted Fri May 26, 2006 02:15 PM

    Hi,

    In built-in service reference guide it is said that pub.db:call is used to execute stored procedures. Is there anyway using which I can invoke an Oracle function. If so, what is the syntax, and required mappings?

    Once it is executed, it returns $dbMessage as the success or error flag.

    How do I get the actual data out if this oracle function is to return out something.

    Any help in this regard is much appreciated… Thanks in advance. :slight_smile:

    Regards,
    Ramesh.


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Invoking Oracle function [using WmDB package]

    Posted Fri May 26, 2006 02:55 PM

    As noted here on wMUsers many times before, you should not use the WmDB adapter. Instead use the JDBC Adapter and its stored procedure or stored procedure with signature templates to invoke an Oracle function.

    Mark


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 3.  RE: Invoking Oracle function [using WmDB package]

    Posted Tue June 06, 2006 06:46 AM

    Thanks Mark, but our client wants us to use only wmDB adapter. So, is there any other work around ?


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


Related Content