begin

mypackage01.queryEmpList(20);

end;

/

create or replace package emp_pack is

  type empcursor is ref cursor;

  procedure emp_pro(emp_id in integer,emp_list out empcursor);

end;

create or replace package body emp_pack is

  procedure emp_pro(emp_id in integer,emp_list out empcursor) is

    begin

    open emp_list for select * from employees e where e.employee_id = emp_id;

    end;

end;

这样调用吗？

 exec emp_pack.emp_pro(1);

使用select func_name() from dual;

像正常函数一样调用就好了