Solved

buffer overflow error

Posted on 2001-07-10
6
1,374 Views
Last Modified: 2008-01-09
I am getting the following error when running an Oracle .sql file.

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 106
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at line 56                    

any idea what I need to do to fix this problem?
Thanks.
0
Comment
Question by:ocean9
6 Comments
 
LVL 6

Expert Comment

by:M-Ali
ID: 6271839
Hi,

You are trying to "output" more than 2000 bytes of information. DBMS_OUTPUT.PUT_LINE has a limit of 2000 bytes max. Reduce the number of characters displayed or split them up into multiple PUT_LINE statements.

Ali
0
 

Expert Comment

by:lolomuros
ID: 6272870
well, you could make bigger de buffer with dbms_output.enable(buffer size);

I think this could help you too.

Good luck, Lolomuros.
0
 
LVL 1

Accepted Solution

by:
bkm earned 50 total points
ID: 6273381
you might have a statement
set serverouput on
in your your script.  Therefore it has taken the default buffer size of 2000.  You can increase this by doing
set serveroutput on size 1000000
this will give you the maximum buffer.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Expert Comment

by:bkm
ID: 6273386
set serveroutput on size 1000000

will do.
0
 

Author Comment

by:ocean9
ID: 6274271
Did not solve the problem.
0
 

Author Comment

by:ocean9
ID: 6274288
Using several DBMS_OUTPUT.PUT_LINE did not solve the problem.  However, increasing the buffer as suggested by 'bkm' did.  Thanks all, for your help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now