web analytics

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

Options

codeling 1599 - 6654
@2017-02-02 15:20:15

I am using a procedure to try to pull data for reporting purposes.  I am getting the following ORA-20000 with ORU-10027 error:

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

@2017-02-02 15:22:23

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

@2017-02-02 15:25:43

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

PL/SQL

DBMS_OUTPUT.ENABLE (NULL);

SQL*Plus

set serveroutput on size unlimited

Comments

You must Sign In to comment on this topic.


© 2024 Digcode.com