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.