Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sys_refcursor

visKJan 19 2010 — edited Jan 19 2010
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2010
Added on Jan 19 2010
2 comments
863 views