Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1405
  • 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
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!

 
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

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!

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