stored Procedure with multiple Result sets

, ,
1

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,

2

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.

3

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

Thanks,
RP