OraFAQ Forum: SQL & PL/SQL » buffer overflow, limit of 1000000 bytes

Home » SQL & PL/SQL » SQL & PL/SQL » buffer overflow, limit of 1000000 bytes (Toad for Oracle)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

buffer overflow, limit of 1000000 bytes [message #335764]

Wed, 23 July 2008 11:55

AlKing
Messages: 11
Registered: July 2008
Location: Bakersfield

Junior Member

Guys,
Whenever I run my code I get this error
----------------------------------------------
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 177
----------------------------------------

I have set the

SET SERVEROUTPUT ON SIZE 1000000

Does it mean I have gone over the 1000000? If so how can I get around this? I have tried to use the UTF_FILE but it does not seem to work for me? Help anyone?

Thanks

Report message to a moderator

Re: buffer overflow, limit of 1000000 bytes [message #335767 is a reply to message #335764]

Wed, 23 July 2008 12:08

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Does it mean I have gone over the 1000000?

Yes.

Quote:

If so how can I get around this?

No way, it is the upper limit in your version (I think as you didn't think it is useful to post it).

Quote:

I have tried to use the UTF_FILE but it does not seem to work for me?

Too bad, it works for me and for everyone that uses it correctly.

Regards
Michel

Report message to a moderator

Re: buffer overflow, limit of 1000000 bytes [message #335768 is a reply to message #335764]

Wed, 23 July 2008 12:14

AlKing
Messages: 11
Registered: July 2008
Location: Bakersfield

Junior Member

Quote
"I think as you didn't think it is useful to post it"

ambigous?

Report message to a moderator

Re: buffer overflow, limit of 1000000 bytes [message #335769 is a reply to message #335764]

Wed, 23 July 2008 12:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Report message to a moderator

Re: buffer overflow, limit of 1000000 bytes [message #335808 is a reply to message #335764]

Wed, 23 July 2008 16:43

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

workaround:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066

Report message to a moderator

Previous Topic:	slow delete
Next Topic:	Sum value of ASCII characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 01 15:29:36 CDT 2025