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

codeling Posts: 1085 Points: 4548
Posted: Thursday, February 2, 2017 3:20:15 PM

I am using a procedure to try to pull data for reporting purposes.  I am getting the following ORA-20000 with ORU-10027 error:

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


codeling Posts: 1085 Points: 4548
Posted: Thursday, February 2, 2017 3:22:23 PM

DBMS_OUTPUT has different default buffer sizes, depending on your Oracle version.  For your system, the limit is 2000 bytes.

You can increase the buffer up to 1,000,000 using the following PL/SQL statement:

 DBMS_OUTPUT.ENABLE(1000000);

The SQL*Plus statement to achieve the same result is:

set serveroutput on size 1000000


codeling Posts: 1085 Points: 4548
Posted: Thursday, February 2, 2017 3:25:43 PM

Starting with Oracle release 10g, it is possible to use the following unlimited buffer settings:

PL/SQL

DBMS_OUTPUT.ENABLE (NULL);

SQL*Plus

set serveroutput on size unlimited

Users browsing this topic
Guest