set serveroutput on size 800000;

declare 
  i_l_id number := 0;
  cur_pocon_prov_id sys_refcursor;
begin

    open cur_pocon_prov_id for 'select aaa from t_aaa ';
    loop 
                fetch cur_pocon_prov_id into i_l_id; 
                exit when cur_pocon_prov_id%notfound; 
               Dbms_Output.put_line(i_l_id); 
                
                
    end loop; 
    close cur_pocon_prov_id;
end;
/