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

  • 1.  JDBC Adapter Stored Procedure Call

    Posted Fri November 30, 2007 11:34 AM

    Hi Administrator,

    Can you pls let me know how to call an Oracle stored procedure in webMethods? Pls provide with example if it is possible.

    Regards,
    Prakash


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


  • 2.  RE: JDBC Adapter Stored Procedure Call

    Posted Fri November 30, 2007 03:52 PM

    Please review the JDBC Adapter User’s Guide. It describes how to call stored procedures.


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


  • 3.  RE: JDBC Adapter Stored Procedure Call

    Posted Fri November 30, 2007 04:29 PM

    Where I can find the document? I dont find at webMethods\Developer\doc\guides

    Regards,
    Jayapraksh.T


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


  • 4.  RE: JDBC Adapter Stored Procedure Call

    Posted Fri November 30, 2007 04:32 PM

    wm_home\Packages\WmJDBCAdapter\docs


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


  • 5.  RE: JDBC Adapter Stored Procedure Call

    Posted Fri November 30, 2007 04:36 PM

    Thanks!

    Regards,
    Jayaprakash.T


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


  • 6.  RE: JDBC Adapter Stored Procedure Call

    Posted Mon January 07, 2013 12:39 PM

    [FONT=PalatinoLinotype-Roman][SIZE=2]I was created stored procedure Notification , but while time it is retrieving all the records but i need new updated records, To ensure that the same data is not published multiple times, design and test your stored procedure so that whenever the stored procedure is invoked , do we need any settings?

    where i need to set the outout record structure?[/SIZE][/FONT]


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


  • 7.  RE: JDBC Adapter Stored Procedure Call

    Posted Tue January 08, 2013 04:55 AM

    some one suggest me in this issue?


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


  • 8.  RE: JDBC Adapter Stored Procedure Call

    Posted Tue January 08, 2013 08:27 AM

    Your stored procedure needs to determine what records are considered updated and which are not. Perhaps it could update the records it processes with a flag of some sort.


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


Related Content