Result Set Pl Sql. A REF CURSOR is a PLSQL data type whose value is the memory address of a query work area on the database. Retrieve result set using getResultSet In PLSQL Supported in PLSQL with DBMS_SQLGET_NEXT_RESULT.
Tim Hall Oracle ACE of the year 2006. They are RETURN_RESULT For returning Ref-Cursor or DBMS_SQL cursor and GET_NEXT_RESULT For processing the implicit result sets in PLSQL which are explained below. Return types of Result Set variables or query do not match.
ORACLE supports Oracle Database - Stored Procedure which returns SQL Engine - Result Set.
RETURN_RESULT This procedure allows us to pass the Ref-Cursors or the DBMS_SQL cursor numbers implicitly rather than wanting us to define them explicitly as OUT parameters. In general using the column index will be more efficient. Create a Stored Procedure in Oracle. PLSQL resultset tips Oracle Tips by Burleson Consulting The following Tip is from the outstanding book Oracle PLSQL Tuning.