sys_refcursor返回结果集输出方法

set serveroutput on
  declare
 v_ret sys_refcursor;
 type typ_row is record ( col_1 varchar2(100),col_2  number ,col_3 number,
   col_4  number ,col_5 number,
   col_6  number ,col_7 number,
   col_8  number ,col_9 number ,col_10 varchar2(100));
   result_temp typ_row;
 begin
    lis.Prc_CTSeasonProvince('8602','','2017-01-01','2017-12-31','01','1',v_ret);
  
           fetch v_ret into result_temp;
          
           while v_ret%found loop
        dbms_output.put_line('字段1：'||result_temp.col_1 );
       fetch v_ret   into result_temp;
    end loop;      
 end;
 /