oracle存储过程带包头包体带光标的存储过程

查询某个部门中所有员工的所有信息

CREATE OR REPLACE
PACKAGE MYPACKAGE AS
 
  type empcursor is ref cursor;
  procedure queryEmpList(dno in number,empList out empcursor);

END MYPACKAGE;
==============================================
CREATE OR REPLACE
PACKAGE BODY MYPACKAGE AS

  procedure queryEmpList(dno in number,empList out empcursor) AS
  BEGIN
     
      open empList for select * from emp where deptno=dno;
   
  END queryEmpList;

END MYPACKAGE;