SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set server output on is not working as expected

User_B8MD6May 11 2015 — edited May 12 2015

Hi Experts

I was running a procedure in 11g database and i have set the SET SERVEROUTPUT ON SIZE UNLIMITED but still i am getting below error. My sqlplus version is "SQL*Plus: Release 11.2.0.3.0 Production"

I checked the code in the procedure and dbms_output.enable is not set anywhere. Is there any internal limit for procedures? Anyone know how to get rid of this error?

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

ORA-06512: at "SYS.DBMS_OUTPUT", line 32

ORA-06512: at "SYS.DBMS_OUTPUT", line 97

ORA-06512: at "SYS.DBMS_OUTPUT", line 112

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2015

Added on May 11 2015

3 comments

930 views