I have an issue with SQL Developer - it is not possible to set
dbms_output buffer larger than 1 000 000 symbols, while it works in SQL*Plus.
SET SERVEROUTPUT ON SIZE UNLIMITED BEGIN for c in (SELECT rpad('a',1000,'a') ll from dual connect by level <=2001) loop dbms_output.put_line (c.ll); end loop; dbms_output.put_line ('www'); END; /
works in SQL*Plus, but fails with:
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 ORA-06512: at line 3
in SQL Developer.
I've tried to use
dbms_output view in SQL Developer and set size to unlimited as described here, but the same amount of symbols is printed and there is no 'www' line. Version of SQL Developer is 4.03.16. Is it a known issue?