Tim, Excellent Mate, You are 100% right. I just did it. (some how my mind didn't work) Can you please explain me a bit more about check point not complete error.
Cheers Mate, Ravi --- Tim Gorman <[EMAIL PROTECTED]> wrote: > 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" > <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> 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" > > > <[EMAIL PROTECTED]> > > > 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). > > === message truncated === __________________________________________________ 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).
