sys_refcursor
visKJan 19 2010 — edited Jan 19 2010Hi
I am trying to create procedure using reference cursor as out parameter. It is throwing following error..
PL/SQL: Compilation unit analysis terminated
PLS-00201: identifier 'SYS_REFCURSOR' must be declared
Procedure body is as follow
create procedure getdata(cur_data out sys_refcursor) is
begin
open cur_data for select * from emp;
end;
The problem occur in 8i , however it works fine in 9i.
let me know whether 8i doesn't support SYS_REFCURSOR or there is some other problem.
Thanks
Vishal