Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
202,301 views