Hello,
I am trying to print dbms_output for more than 200000 thousands records but its failing after a certain limit.
I would need to print at least 200000 records, is that possible? or what is the max dbms_output limit in sqlplus?
I use Oracle 11g
declare
begin
dbms_output.enable(1000000);
for i in 1..200000
loop
dbms_output.put_line(i);
end loop;
end;
/
185184
declare
*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 6