Solved

buffer overflow error

Posted on 2001-07-10
6
1,385 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

688 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