put_line cannot print more than 2000 characters

Cube874

Member²
Hello, having some trouble printing to the console when the string I'm printing has > 2000 characters. An example script is:

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)
 
This is indeed a known restriction. Each line cannot be more than 4000 bytes. This is resolved in PL/SQL Developer 8.0.
 
Back
Top