Hello, having some trouble printing to the console when the string I'm printing has > 2000 characters. An example script is:
When I run this script, only 2000 characters are printed. Running the same script in SQL*Plus and Oracle SQL Developer results in 2009 characters being printed. Is there some setting in PL/SQL Developer that controls this or is it a bug?
(PL/SQL Developer version: Version 7.1.5.1398)
Code:
set serveroutput on size 100000;
declare
big_str varchar2(2009);
begin
for i in 1..2009 loop
big_str := big_str||'x';
end loop;
dbms_output.put_line(length(big_str));
dbms_output.put_line(big_str);
end;
/
When I run this script, only 2000 characters are printed. Running the same script in SQL*Plus and Oracle SQL Developer results in 2009 characters being printed. Is there some setting in PL/SQL Developer that controls this or is it a bug?
(PL/SQL Developer version: Version 7.1.5.1398)