PLSQL Error

Error:

ORA-20000: ORU-10027: buffer overflow, limit of 20000 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

Solution

 DBMS_OUTPUT.ENABLE(1000000);

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


DBMS_OUTPUT.ENABLE (buffer_size => NULL);