SolutionS

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

ERROR at line 1:

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

Description:

When I m running the pl&sql procedure I  ve got the following above error .This is error might be occur due to the amount of information, in bytes, to buffer.  Varchar2, number and date items are stored in their internal representation.  The   information is stored in the SGA. An error is raised if the buffer size is exceeded.  If there are multiple calls to enable,   then the buffer size is generally the largest of the values specified, and will always be >= than the smallest value specified.  Currently a more accurate determination is not possible.  The maximum size is 1,000,000, the minimum is 2000.

Solution:

To change the default buffer size to 150,000 characters use a call   similar to the following within a PL/SQL block:

         DBMS_OUTPUT.ENABLE (150000);

  (Where 150000 is the required buffer size)

To see output from DBMS_OUTPUT.PUT_LINE and similar calls in SQL*Plus   Or Server Manager uses the command:

         SET SERVEROUTPUT ON

This causes SQL*Plus / Server Manager to use DBMS_OUTPUT.GET_LINES to   read the output and writes it to the terminal.