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 Service calling Stored proc, returns ref cursor

    Posted Mon December 22, 2008 10:21 PM

    I’m calling stored procedure through WM JDBC adapter service which returns a reference cursor. But while invoking the adapter service I’m getting the following error. Can someone please help me out on this.

    com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service adapterServices:reconcileShipmentEquipmentAdpSvc.
    [ADA.1.316] Cannot execute the SQL statement “{call CARDEX.CARDEX_WRAPPER.RECON_SHIPMENT_EQUIP_WRAPPER( ?, ?, ?, ?, ?, ?, ?)}”. "
    (0) Cursor is closed."
    Cursor is closed.


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


  • 2.  RE: JDBC Adapter Service calling Stored proc, returns ref cursor

    Posted Tue January 06, 2009 02:28 AM

    What is the patch level on your JDBC adapter and what version of the adapter are you using?


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


  • 3.  RE: JDBC Adapter Service calling Stored proc, returns ref cursor

    Posted Thu March 12, 2009 02:23 PM

    Hi Ajit,

    How did you resolve this issue ? Please let me know.I am also stuck up with similar problem.

    Thanks
    Haritha


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


  • 4.  RE: JDBC Adapter Service calling Stored proc, returns ref cursor

    Posted Mon June 14, 2010 10:26 PM

    Hi,
    Is anyone able to resolve this? Please let me now, stuck with the same issue.

    Thanks,


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


  • 5.  RE: JDBC Adapter Service calling Stored proc, returns ref cursor

    Posted Tue May 29, 2012 08:47 AM

    Hi wmusers,

    can any one responde with the solution for the above problem. facing same problem.

    My code is in Prod server and running since last month… all of a sudden, started to getting the error mails like…(0) Cursor is closed.

    : [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service …procedere_name.
    [ADA.1.316] Cannot execute the SQL statement “{call procedere_name (?, ?, ?, ?, ?, ?, ?, ?) }”. "
    (0) Cursor is closed."
    Cursor is closed.

    Please can anyone have any answer for this…

    Thanks in advance.

    Thanks
    npbkwm


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


  • 6.  RE: JDBC Adapter Service calling Stored proc, returns ref cursor

    Posted Mon June 04, 2012 09:21 PM

    Hi
    When the response is null and webMethods trying to reference that cursor, you will get that error.
    in the Stored procedure script, try sending an empty cursor instead of null and see if u can over come this problem

    HTH


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


Related Content