Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_output.put_line error...

user520824Feb 28 2011 — edited Mar 1 2011
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
This post has been answered by Solomon Yakobson on Feb 28 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2011
Added on Feb 28 2011
5 comments
5,235 views