CREATE OR REPLACE PROCEDURE GET_DATA(p_cursor OUT SYS_REFCURSOR, nRecs OUT INTEGER) IS BEGIN OPEN p_cursor FOR SELECT * FROM SOME_TABLE WHERE ...; SELECT COUNT(0) INTO nRecs FROM SOME_TABLE WHERE ...; ... END GET_DATA;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)