Home » SQL & PL/SQL » SQL & PL/SQL » buffer overflow, limit of 1000000 bytes (Toad for Oracle)
buffer overflow, limit of 1000000 bytes [message #335764] Wed, 23 July 2008 11:55 Go to next message
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
Re: buffer overflow, limit of 1000000 bytes [message #335767 is a reply to message #335764] Wed, 23 July 2008 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: buffer overflow, limit of 1000000 bytes [message #335768 is a reply to message #335764] Wed, 23 July 2008 12:14 Go to previous messageGo to next message
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?
Re: buffer overflow, limit of 1000000 bytes [message #335769 is a reply to message #335764] Wed, 23 July 2008 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: buffer overflow, limit of 1000000 bytes [message #335808 is a reply to message #335764] Wed, 23 July 2008 16:43 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
workaround:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
Previous Topic: slow delete
Next Topic: Sum value of ASCII characters
Goto Forum:
  


Current Time: Fri Dec 09 17:29:37 CST 2016

Total time taken to generate the page: 0.27751 seconds