You Asked
Hi Tom,
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.
Mal.
and Tom said...
ops$tkyte%ORA10GR2> set serveroutput on size unlimited
ops$tkyte%ORA10GR2>
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.
Is this answer out of date? If it is, please let us know via a Comment