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

I got “ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes ”  error in Oracle database.

 

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

 

Details of error are as follows.

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 28
ORA-06512: at line 311

 

 

ORU-10027: buffer overflow, limit of 2000 bytes

This ORU-10027 error is related with the  default buffer sizes depend on the oracle version.

You should  increase the buffer size as follows.

SQL> DBMS_OUTPUT.ENABLE(20000)
SQL> set serveroutput on size 200000

 

You can set buffer size unlimited as follows.

SQL> DBMS_OUTPUT.ENABLE (buffer_size => NULL);

SQL> set serveroutput on size unlimited

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

See more