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
Back to discussions
Expand all | Collapse all

Problem in configuring ref cursor Stored procedure resultset

  • 1.  Problem in configuring ref cursor Stored procedure resultset

    Posted Fri June 23, 2006 03:31 PM

    I am able to configure Stored procedure with IN, OUT, INOUT parameters, it works fine. i am able to configure ref cursor parameter stored procedure also, but when i try run stored procedure i got the following error message.

    “com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Poc_loop:ref_cur_sp.
    [ADA.1.316] Cannot execute the SQL statement “{call SAMPLEPKG.REFCURSAMPLESP (?, ?) }”. "
    COLOR=red [wm-cjdbc33-0069][Oracle JDBC Driver]No more data available to read."[/color]
    [wm-cjdbc33-0069][Oracle JDBC Driver]No more data available to read.”


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


Related Content