I see below behaviour in both 17.4.0.354.2224 and 17.3.0.256.1818
It seems sqlcl doesn't handle "set serveroutput size unlimited".
Or am I missing something?
Using 'unlimited' for size in the "set serveroutput" command is accepted without errors, but buffersize remains 1M.
Below script sets serveroutput size to unlimited and then tries to output 1500 lines of 1000 characters, so 1.5M bytes (plus some for end-of-line).
set serveroutput on size unlimited format wrapped
spool junk
declare
c_line constant varchar2(1000) := rpad('x',1000,'x');
begin
for i in 1 .. 1500
loop
dbms\_output.put\_line (c\_line);
end loop;
end;
/
spool off
in sqlplus the result is:
in sqlcl, however:
