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

Calling Stored Procedure using JDBC Adapter

  • 1.  Calling Stored Procedure using JDBC Adapter

    Posted Thu October 13, 2005 07:31 AM

    I have a stored procedure in Oracle named USGC_PROC_TEST1 and I am calling it using the StoredProcedure template of JDBC Adapter from Developer.But when I am running the Service it gives me this error.

    com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service D106Exercises.Exercises8:SPDone.
    [ADA.1.316] Cannot execute the SQL statement “{call USGC_PROC_TEST1}”. "
    (21000/1422) ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at “SYSTEM.USGC_PROC_TEST1”, line 7
    ORA-06512: at line 1

    Is there any way to solve this problem.


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


  • 2.  RE: Calling Stored Procedure using JDBC Adapter

    Posted Fri October 14, 2005 11:33 AM

    Hi Mitul,

    what is the store procedure returning?


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


Related Content