Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

No big mystery. When they run it in the other database, they generate less than 2000 bytes of output. When it fails, it is overflowing the buffer of 2000 bytes, as the error message indicates.

If they continue to argue, then don't argue back. Just prove it by setting the buffer size higher to allow the output to come out, and then compare spooled output. Nothing stops an argument faster than proof...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, June 29, 2002 2:08 PM

> Hi Tim,
>
> Thanks for the response, but that is not the
> point,here developers question is why it is working in
>
> other database? (sure they haven't set anything over
> there)
>
> thanks,
> ravi
>
> --- Tim Gorman <Tim_at_SageLogix.com> wrote: > Ravi,
> >
> > The DBMS_OUTPUT package stores all output from
> > PUT_LINE commands into a
> > buffer, and this error indicates you are overflowing
> > this buffer. The
> > default size is 2000. If you are executing from
> > SQL*Plus you can change the
> > size of the DBMS_OUTPUT buffer using the "SET
> > SERVEROUTPUT ON SIZE n", where
> > "n" is 1000000 or less...
> >
> > Alternatively, if you are not using SQL*Plus, then
> > you can change the buffer
> > size using "DBMS_OUTPUT.ENABLE(n)", where "n" is the
> > size...
> >
> > Hope this helps...
> >
> > -Tim
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Saturday, June 29, 2002 11:38 AM
> >
> >
> > > Dear All,
> > >
> > > When We run simple pl/sql we are getting the
> > follwoing
> > > error
> > > ORA-20000: ORU-10027: buffer overflow, limit of
> > 2000
> > > bytes.
> > >
> > > But the fact is it is running fine in another
> > database
> > > Completely on different server).
> > >
> > > I have compared the following thigs please let me
> > know
> > > if there is anything else to check other than the
> > > follwoing one's.
> > >
> > > 1) DB version is same on both the site i.e
> > 8.1.7.0.0
> > > 2) source for dbms_output is same both the
> > systems. I
> > > even checked it from dba_source text and
> > everything is
> > > equal.
> > > 3) we don't specify anything in either login.sql
> > or
> > > glogin.sql.
> > > 4) pl/sql simple one is running same same one is
> > > running.
> > >
> > > Please let me know if I miss anything else other
> > than
> > > the above.
> > >
> > > Cheers,
> > > ravi.
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Everything you'll ever need on one web page
> > > from News and Sport to Email and Music Charts
> > > http://uk.my.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: =?iso-8859-1?q?Nalla=20Ravi?=
> > > INET: vvnrk2001_at_yahoo.co.uk
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Tim Gorman
> > INET: Tim_at_SageLogix.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Nalla=20Ravi?=
> INET: vvnrk2001_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).