web analytics
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes Options
codeling
Posted: Thursday, February 2, 2017 3:20:15 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 931
Points: 3909

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

Sponsor
Posted: Thursday, February 2, 2017 3:20:15 PM
codeling
Posted: Thursday, February 2, 2017 3:22:23 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 931
Points: 3909

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

codeling
Posted: Thursday, February 2, 2017 3:25:43 PM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 931
Points: 3909

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

Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2018 Digcode.com. All rights reserved.