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

on


 

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);



Comments

Post a Comment