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

今天在执行存储过程时，捕捉到异常错误

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

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

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

• PL/SQL: DBMS_OUTPUT.ENABLE (buffer_size => NULL);

• SQL*Plus: set serveroutput on size unlimited