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!

ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

444572May 25 2005 — edited Nov 30 2011
Hi,
I am generating a report by using dbms_output.putline, and set the buffer size to 1000000, but while i am generating the report its still giving the error ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes. Is there any mechanism to check the free space in the buffer, and then printing the ouput.

please give me a solution.

Thanking you,
Chenna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2011
Added on May 25 2005
18 comments
203,781 views