Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: buffer overflow
Hi!
On Jan 24, 12:34pm, Andersen Consultant wrote:
> Subject: buffer overflow
> Hi guys - I'm doing dynamic SQL updates in a PL/SQL procedure. The code is
> fine, and I have a DBMS_OUTPUT.PUT_LINE to make sure it is constructing the
> update statements correctly. It chugs along for a while, and then I get a
> buffer overflow error. The error is ORU-10027: buffer overflow, limit of
> 2000 bytes. I was wondering if this refers to the SQL buffer and how I can
> increase its size. Thanks in advance - Jim
>-- End of excerpt from Andersen Consultant
In sqlplus you type:
" set serveroutput on size 65536"
and if you use some other tool then you add the following line to your PL/SQL:
"dbms_output.enable(65536);"
Hope this helps!
--
Mladen Gogala
ASTER Ljubljana
Tel : ++386 61 1683-511 Snail-mail: FAX : ++386 61 1683-165 ASTER Ljubljana Email: gogi_at_aster.si Nade Ovcakove 1 WWW : www.aster.si 61000 Ljubljana SloveniaReceived on Fri Jan 26 1996 - 13:42:52 CST
![]() |
![]() |