|
|
|
|
|
|
|
Re: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes [message #413797 is a reply to message #413759] |
Fri, 17 July 2009 12:10   |
prachij593
Messages: 266 Registered: May 2009
|
Senior Member |
|
|
Michel Sir,
As I said, in my main procedure I have an alternative to avoid dbms_output.put_line. I created a table and recorded the data.
But its the other procedure which are using DBMS_OUTPUT.PUT_LINE
to track the data flow. I can't modify those.
In my main procedure I am just loopong through cursor and pass the value to a procedure. [Sorry for unable to provide the code]
Quote: |
Yes set the buffer size to unlimited but you will have many other problems.
|
What are the problems if we can set size to more than 1000000
say 3000000
SQL> SET SERVEROUTPUT ON SIZE 1000000000
SP2-0547: size option 1000000000 out of range (2000 through 1000000)
SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0
Many thanks...
[Updated on: Fri, 17 July 2009 12:12] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes [message #413836 is a reply to message #413808] |
Fri, 17 July 2009 15:17   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
prachij593 wrote on Fri, 17 July 2009 14:12 |
The dbms_output is not in the main procedure but in other calling procedures (which were used to keep track of data flow)
And now I am running that procedure as a batch. Passing values
through a cursor. Its more than 50k rows
|
1. What "other" procedures?
2. What does "keeping track of data flow" mean?
3. What is "that" procedure?
Why don't you show us a clear structured example of what you are doing.
|
|
|
|
|