oracle ora20002,请教ora-2000问题?

帮朋友问个问题，如下

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

Tim Gorman

Sat, 29 Jun 2002 13:50:46 -0700

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"

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 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"

> >

> > 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: [EMAIL PROTECTED]

> > >

> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

> >

> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

>

> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).