Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1417
  • Last Modified:

buffer overflow error

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
ocean9
Asked:
ocean9
1 Solution
 
M-AliCommented:
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
 
lolomurosCommented:
well, you could make bigger de buffer with dbms_output.enable(buffer size);

I think this could help you too.

Good luck, Lolomuros.
0
 
bkmCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
bkmCommented:
set serveroutput on size 1000000

will do.
0
 
ocean9Author Commented:
Did not solve the problem.
0
 
ocean9Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now