This is most probably some sort of settings problem, but I'm just hoping somebody here has an idea how I can fix this.

Below problem occurs on my customer laptop in PLSQL Developer.
My coworkers don't have this issue and I don't have this issue on my own laptop (having, as far as I know the same plsql developer settings as my work laptop).

plsql developer version: 15.0.4.2064
Database version : 19.19
OS: Windows 10 (customer laptop) Windows 11 (Own laptop)

The issue
dbms_output.put_line is supposed to accept varchar2 strings up to 32.767 in length.
But on my customer laptop, if I pass it a string of 32.513 or more I get a "PL/SQL numeric or value error: character string buffer too small"

See attached screenshot
Running:
begin
dbms_output.put_line (rpad('X',32513,'X'));
end;
/

produces the error.
Doing the same thing but rpadding it to 32512 runs without problems.
As stated above, on all other laptops doing the exact same thing but rpadded to the max of 32767 is not a problem at all.

The limit of 32512 is 255 lower than the limit of put_line, with is I think a suspicious number.

Anybody any idea what could be causing this??

Attached Files
2023-07-20_PD_Output_Error.png (28.86 KB, 85 downloads)

Erik van Roon
EvROCS