most of the time, we use packages which return ref cursor as output to the application layer, using Code test how can i view my ref cursor output
here is the sample code
PROCEDURE PRC_Get_EmpDetails(i_deptno number, o_success OUT SYS_REFCURSOR, o_ErrorCode OUT VARCHAR2)
is
xxxxxxxxxxx
begin
XXXXXXXXXXXX
xxxxxxxxxxxxx
open o_success for select emp_id,salary, first_name,last_name from employees where deptartment_id=i_detpno;
o_Errorcode := ‘SQL_OK’;
end;
Appreciate your help
