Stored procedure 에서 cursor 리턴 처리

create or replace procedure proc_test ( aFlag in varchar2, csr01 out sys_refcursor )

is

begin

    open csr01 for

    select * from test

     where flag = aFlag;

end;

 

SQL> var csr refcursor;