Hello All,
Hope all are doing well. Thanks for reading this post and hope will get some assistance to resolve my issue.

How can I retrieve multiple Result Sets which are coming from a storedProcedure into webMethods

Signature of stored Procedure is :

CREATE OR replace PROCEDURE SPTwoRefCursor (catCur OUT SYS_REFCURSOR, prodCur OUT SYS_REFCURSOR )
IS
BEGIN
OPEN catCur FOR SELECT * FROM “EMP”;
OPEN prodCur FOR SELECT * FROM “EMP1”;
END

SQL> desc emp;
Name Null? Type

EMPID NUMBER(5)
ENAME VARCHAR2(20)
MGR NUMBER(5)
SAL NUMBER(10,2)
DEPT NUMBER(5)

SQL> desc emp1;
Name Null? Type

SALARY NUMBER(15,2)
EID NUMBER(4)

My DB is Oracle and wM8.2.

Thanks,

When you create a JDBC adapter service, under the ResultSet tab, you can create multiple results sets, just give different name for each set and define column under each set.

Thanks Wang for your reply. I will try that option.

Thanks,
RP