[SQL] ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes

 

The error ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes occurs in Oracle when an attempt is made to write more than 20,000 bytes to the DBMS_OUTPUT buffer. This buffer has a default size limit, which can be increased or managed. 

You can increase the buffer size of DBMS_OUTPUT in SQL*Plus or any other PL/SQL environment. Use the following command before executing your PL/SQL block: 

SET SERVEROUTPUT ON SIZE UNLIMITED;

or

SET SERVEROUTPUT ON SIZE 1000000;

Or, use the below statements:

exec dbms_output.enable(1000000);

or

exec dbms_output.enable(NULL);