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).
Received on Sat Jun 29 2002 - 15:08:26 CDT