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.
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.
well, you could make bigger de buffer with dbms_output.enable(buffer size);
I think this could help you too.
Good luck, Lolomuros.
I think this could help you too.
Good luck, Lolomuros.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
set serveroutput on size 1000000
will do.
will do.
ASKER
Did not solve the problem.
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.
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