oracle 创建游标

create or replace package mypackt is
  type myCursor is ref cursor;
  end mypackt;
create or replace procedure getDept(v_deptno dept.deptno%type
                                                                    v_cursor out mypackt.myCursor) is
begin
open v_cursor for
     select * from dept where deptno=v_deptno;
  end getDept;