webMethods

webMethods

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
  • 1.  Call a Oracle PL/SQL from a Java service

    Posted Thu October 06, 2016 10:09 AM

    Hi,

    I’m trying to call a specific PL/SQL but I have many problem with the StoredProcedureWithSignature Adapter.
    So to deal more efficiently with my Proc (it has many OUT ARRAY parameters), I would like to call it within a Java service.

    Could you please give me a Java code source example to call my PROC please ?
    Of course, I would need first, the code for calling my existant JDBC connection.

    Finally, if you could give me some links to Java examples or webMethods Java implementing, I would appreciate it.

    Regards


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


  • 2.  RE: Call a Oracle PL/SQL from a Java service

    Posted Fri October 07, 2016 01:07 PM

    hi,
    if you just would have some pages with code samples to recommand me it would be great. :wink:
    regards


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


  • 3.  RE: Call a Oracle PL/SQL from a Java service

    Posted Sat October 08, 2016 06:35 AM

    Please go through below links:

    Thanks,


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


  • 4.  RE: Call a Oracle PL/SQL from a Java service

    Posted Sat October 08, 2016 07:49 AM

    thanks but my question was more oriented ARRAY within webMethods and webMethods JDBC connections : how to call an existent connection…
    I’ve already coded a lot of java application which call PROC and FUNCTIONS ORACLE :slight_smile:

    but looking and looking over the net, I’ve found this :

    http://techcommunity.softwareag.com/ecosystem/communities/public/webmethods/contents/codesamples/964b2515-07b9-11e6-b2c6-cd8d7ef22065/?title=Using+webMethods+JDBC+Adapter+Connection+in+custom+Java+code

    Regards


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


  • 5.  RE: Call a Oracle PL/SQL from a Java service

    Posted Sun October 09, 2016 11:19 AM

    Gotcha. Is the sample available there serving your need.

    Thanks,


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