create global temporary table test (
  test_id number ( 9 )
) on commit preserve rows
/

insert into test
select rownum from all_objects where rownum <= 100 ;
commit;
/

SQL> set serveroutput on
SQL>  exec dbms_output.enable( 20000 );

PL/SQL procedure successfully completed.

SQL> select count(*) from test;

  COUNT(*)
 ----------
 
        100 

SQL> declare type t_refcursor is ref cursor;
   2           cr t_refcursor;
   3           v number( 9 );
   4           c number( 9 ) :=  0 ;
   5           procedure get_cr (p_cr out t_refcursor) is
   6           begin
   7             open p_cr for
   8               select test_id from test;
   9           end;
  10   begin
  11     get_cr(cr);
  12     commit;
  13     loop
  14       fetch cr into v; exit when cr%notfound;
  15       c := c +  1 ;
  16     end loop;
  17     dbms_output.put_line('count='||c||';');
  18   end;
  19   /
count= 100 ;