DBMS OUTPUT SAVE LINES BEFORE DISABLE
declare v_dbms_array dbms_output.chararr; v_line_count integer:=1000000; begin dbms_output.enable; dbms_output.put_line('1'); dbms_output.put_line('2'); dbms_output.get_lines(v_dbms_array, v_line_count); dbms_output.disable; dbms_output.enable; FOR i IN 1 .. v_line_count LOOP dbms_output.put_line(v_dbms_array(i)); END LOOP; dbms_output.put_line('3'); end; /
Leave a comment