Link to home
Start Free TrialLog in
Avatar of ocean9
ocean9

asked on

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.
Avatar of M-Ali
M-Ali
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
Avatar of lolomuros
lolomuros
well, you could make bigger de buffer with dbms_output.enable(buffer size);

I think this could help you too.

Good luck, Lolomuros.
ASKER CERTIFIED SOLUTION
Avatar of bkm
bkm
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bkm
bkm
set serveroutput on size 1000000

will do.
Avatar of ocean9
ocean9

ASKER

Did not solve the problem.
Avatar of ocean9
ocean9

ASKER

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.