One of our PL/SQL Programs, which is supposed to generate about 100000 records at every run with required format output But after running this PL/SQL Program, the error "ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes" is being generated even after we set "SET SERVEROUTPUT ON SIZE 100000".
We are luckily on 10gR2. So, it supports UNLIMITED size i.e "SET SERVEROUTPUT ON SIZE UNLIMITED". We set this in the PL/SQL Program, after that no buffer over flow error generated.
Regards,
Sabdar Syed.
Subscribe to:
Post Comments (Atom)
1 comment:
Hi,
While running a PL/SQL program I am also getting the error like "ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes".
Can there be any other reasons for the same.
I am using Oracle 9i.
Thanks in advance!
Post a Comment