Hi Masters,
I have created a function which will return result set from emp table. I have to utilize this resultset in another procedure/function. Is it possible?
I have writtne a function like this..
create or replace function test (v_sal in number) return sys_refcursor is
v_cur sys_refcursor;
begin
open v_cur for select * from emp where sal>=v_sal;
return v_cur;
end;
SQL> select test(2000) from dual;
6 rows displayed.
I need to use this records to filter in another subprogram? is it possible? Please advise..!!!
Regards
AP