Differences

This shows you the differences between two versions of the page.

db2-to-oracle:process_result_sets_in_procedures [September 06, 2013 4:16 am]
sqlines
db2-to-oracle:process_result_sets_in_procedures [September 06, 2013 4:18 am] (current)
sqlines
Line 2: Line 2:
In DB2, a stored procedure can process result set(s) returned by another stored procedure using RESULT_SET_LOCATOR type, ASSOCIATE RESULT SET LOCATORS and ALLOCATE CURSOR FOR RESULT SET statements. In DB2, a stored procedure can process result set(s) returned by another stored procedure using RESULT_SET_LOCATOR type, ASSOCIATE RESULT SET LOCATORS and ALLOCATE CURSOR FOR RESULT SET statements.
 +
 +In Oracle you can use SYS_REFCURSOR type to pass result sets between stored procedures.
**Last Update:** DB2 10.1 and Oracle 11g R2. **Last Update:** DB2 10.1 and Oracle 11g R2.