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.

 View Only
Expand all | Collapse all

How do we do oracle function calls in webmethods

  • 1.  How do we do oracle function calls in webmethods

    Posted Thu March 20, 2003 09:03 PM

    how do we do oracle function calls in webMethods? We have utilities for making procedure calls in webMethods. But how do we make function calls to oracle?

    thanks,
    Srinivas


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


  • 2.  RE: How do we do oracle function calls in webmethods

    Posted Thu September 08, 2016 08:06 AM

    hi community,
    i have the same question is there any body can answer please,

    Regards,
    Nezha


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


  • 3.  RE: How do we do oracle function calls in webmethods

    Posted Thu September 08, 2016 02:42 PM

    Hi,

    what exactly are you referring to when mentioning function calls?

    In JDBC Adapter you can try to use “Custom SQL” service template…

    Regards,
    Holger


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


  • 4.  RE: How do we do oracle function calls in webmethods

    Posted Fri September 09, 2016 03:21 PM

    As suggested by Holger, custom sql should work for your requirement. You may also explore SP for executing stored procedure.


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


  • 5.  RE: How do we do oracle function calls in webmethods

    Posted Sun September 11, 2016 02:35 PM

    R& D on CustomSQL will serve your purpose. Also there are a couple of threads on this forum, search those.

    Thanks,


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


  • 6.  RE: How do we do oracle function calls in webmethods

    Posted Wed September 14, 2016 07:14 AM

    hi,
    thank you evreyone for yr answers, SP did the work :slight_smile:

    Regards,
    Nezha


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


  • 7.  RE: How do we do oracle function calls in webmethods

    Posted Wed September 14, 2016 11:36 AM

    Glad to hear. Share the steps you followed which will be helpful in future to others.

    Thanks,


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


  • 8.  RE: How do we do oracle function calls in webmethods

    Posted Thu September 15, 2016 06:19 AM

    hi,
    i just use a jdbc adapter to create a stored procedure,

    As i see webMethods deal with functions like SP so it dosn’t make any difference it’s the same treatment,

    Regards,
    Nezha


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


  • 9.  RE: How do we do oracle function calls in webmethods

    Posted Thu September 15, 2016 04:53 PM

    Cool. Great for sharing what you did :smiley:

    Thanks,


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