I hit the below error from an oracle application I developed.
"ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes"
I am aware that max buffer limit is '1000000'. I am not sure where does the application gets '10000' value from?
I have checked the whole sourcecode already. I don't set this value anywhere.
When i tried to simulate myself thro a small declare, begin and end procedure, i could only get the same error only if i had deliberately set dbms_output.enable(10000). Else i dont hit the error.
Now i have 2 questions.
Application level: Since i hit the buffer overflow, is there any way i can store content of the buffer somewhere? (to trace on my application errors)
Oracle level: of course, how to utilize the 1000000 buffer size and not 10000?
Does oracle sets this value automatically depending on environment conditions?
Appreciate your kind answers.
and Tom said...
Is this answer out of date? If it is, please let us know via a Comment
ops$tkyte%ORA10GR2> set serveroutput on size unlimited
In your login.sql file or glogin.sql (global logon.sql) - you must be setting serveroutput on size 10000
You can control it using serveroutput - and in 10g and above, it can be set to unlimited.