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.