Home » SQL & PL/SQL » SQL & PL/SQL » ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes (oracle 9i)
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes [message #287312] Tue, 11 December 2007 22:42 Go to next message
sudharshan
Messages: 48
Registered: November 2006
Member
CREATE OR REPLACE PROCEDURE APPS.plsql_tables
IS
   TYPE header_id_type IS TABLE OF oe_order_headers_all.header_id%TYPE
      INDEX BY PLS_INTEGER;

   header_id_tab   header_id_type;

   CURSOR c1
   IS
      SELECT header_id
        FROM oe_order_headers_all;

   i number:= 0;
BEGIN

   FOR prec IN c1
   LOOP
      i := i + 1;
      header_id_tab (i) := prec.header_id;
      dbms_output.put_line('the value of header value '||header_id_tab(i));
   END LOOP;
   
  
END plsql_tables;


SELECT COUNT(*) FROM OE_ORDER_HEADERS_ALL;

COUNT
-----
987089


WHEN I EXECUTE THIS PROCEDURE I GET THIS ERROR

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

WHAT I TRIED IN TOAD

FROM TOAD OPTIONS--> I INCREASED THE BUFFER SIZE TO

10000000


REGARDS
SUDHARSHAN
Re: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes [message #287326 is a reply to message #287312] Tue, 11 December 2007 23:38 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

it's a DBMS_OUTPUT error as your have already found out.so search for a alternate for DBMS_OUPUT.i think in 10g this limitation has been removed.search google for DBMS_OUTPUT and you will find many workarounds.


regards,
Re: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes [message #287329 is a reply to message #287312] Tue, 11 December 2007 23:46 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8633
Registered: November 2002
Location: California, USA
Senior Member
See the my_dbms_output solution in the following link:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
Re: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes [message #287330 is a reply to message #287312] Tue, 11 December 2007 23:49 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

check below link
http://forums.oracle.com/forums/thread.jspa?threadID=306557

http://www.google.ae/search?hl=en&q=ORU-10027%3A+buffer+overflow%2C+limit+of+1000000+bytes+10g&meta=

hope this help
Previous Topic: equivalent querry / NOT EXISTS (merged)
Next Topic: Time Increment
Goto Forum:
  


Current Time: Tue Dec 06 04:45:41 CST 2016

Total time taken to generate the page: 0.07569 seconds