Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: buffer overflow

Re: buffer overflow

From: Mladen Gogala <gogi_at_ASTER.SI>
Date: Fri, 26 Jan 1996 09:41:07 +0100
Message-Id: <9601261842.AA23023@alice.jcc.com>


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
                                         Slovenia

Received on Fri Jan 26 1996 - 13:42:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US