SQL> l
  1  declare
  2   vt my_type;
  3   c1 sys_refcursor;
  4  begin
  5   open c1 for select my_object(empno) from emp;
  6   fetch c1 bulk collect into vt ;
  7   dbms_output.put_line(vt.last);
  8   close c1;
  9* end;
SQL> /
14

PL/SQL procedure successfully completed.

  1  declare
  2   c1 sys_refcursor;
  3   procedure p(p_c in sys_refcursor) is
  4     vt my_type;
  5   begin
  6     fetch c1 bulk collect into vt ;
  7     dbms_output.put_line(vt.last);
  8     close c1;
  9   end;
 10  begin
 11   open c1 for select my_object(empno) from emp;
 12   p(c1);
 13   open c1 for select my_object(deptno) from dept;
 14   p(c1);
 15* end;
SQL> /
14
4

PL/SQL procedure successfully completed.

  1  declare
  2   c1 sys_refcursor;
  3   procedure p(p_c in sys_refcursor) is
  4     vt my_type;
  5   begin
  6     fetch c1 bulk collect into vt ;
  7     dbms_output.put_line(vt.last);
  8     close c1;
  9   end;
 10   procedure po(p_s in varchar2,p_c out sys_refcursor) is
 11   begin
 12     open c1 for p_s;
 13   end;
 14  begin
 15   po('select my_object(deptno) from emp',c1);
 16   p(c1);
 17   open c1 for select my_object(deptno) from dept;
 18   po('select my_object(deptno) from dept',c1);
 19   p(c1);
 20* end;
SQL> /
14
4

PL/SQL procedure successfully completed.