SQL Developer

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!

Command Skipped: SET SERVEROUTPUT ON SIZE 1,000,000

rockie12Nov 15 2006 — edited Aug 21 2007

SET SERVEROUTPUT ON SIZE 1,000,000;
declare
v_jan number;
v_feb number;

I put this at the top of my sql block in sql developer and when I run it I get the following...

line 1: SQLPLUS Command Skipped: SET SERVEROUTPUT ON SIZE 1,000,000;

Error starting at line 2 in command:
declare.... [ rest of code block here] ... then...

Error report:
ORA-20000: ORU-10027: buffer overflow, limit of 20000 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
ORA-06512: at line 13

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2007

Added on Nov 15 2006

#sql-developer

4 comments

10,744 views