Toad World® Forums

Refernce cursor opening problem

PLS-00361: IN cursor ‘N_EMP_CURSOR’ cannot be OPEN’ed

type emp_cursor is ref cursor return emp%rowtype;function

end emp_package_ref_cursor;

 

begin

open n_emp_cursor for select empno,ename,sal,comm from emp where job in ‘Clerk’;return

end emp_package_ref_cursor;

end sf_open_cursor_emprec;

Hi
Apologies for the big code…I am getting the error:–

in the following code . pls suggest the reason and the solution for the same…

create or replace package emp_package_ref_cursor as sf_open_cursor_emprec(n_emp_cursor emp_cursor) return emp_cursor;create or replace package body emp_package_ref_cursor asfunction sf_open_cursor_emprec(n_emp_cursor emp_cursor) return emp_cursor as n_emp_cursor;