Toad World® Forums

how to see ref cursor output

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

You can use Programs - Run Program window:

After successfully running the code, you can see the results in Outcomes tab: