Oracle dbms_output.put_line only displays ??? in message window

[MudGuard]

Hi,

I try to do some output to the Message window in SqlWorkbench, connected to Oracle 12g database.

I tried the following:

CREATE OR REPLACE PROCEDURE AndreasTest AS
BEGIN
  dbms_output.put_line('DEBUG: starting ');
  dbms_output.put_line('DEBUG: middle ');
  dbms_output.put_line('DEBUG: finished ');
END;
/

then for running the procedure:

set serveroutput on;
exec AndreasTest();

the result:

Execution time: 0ms
Statement 1 of 2 finished (2022-04-13 15:59:59.901)

???
???
???

AndreasTest executed successfully

Execution time: 6ms
Statement 2 of 2 finished (2022-04-13 15:59:59.925)


Script execution finished (2022-04-13 15:59:59.937)
Total script execution time: 6ms

If I change the number of put_line calls, this will change the number of "???" lines in the output.
If I use SET SERVEROUTPUT OFF  the lines with the ??? will not appear.
So SET SERVEROUTPUT is working.
The put_line only works insofar as it creates a ??? line - but not a line with the given text.

Do I need to configure something to get the real text instead of the ???

It does not help to replace the "exec" with "wbCall" ...

Thanks in advance

Andreas

[Thomas Kellerer]

Hmm, I canot reproduce this. But I only have access to an Oracle 19 database.

But the code for that hasn't changed for ages and I am 100% sure it worked backed when we were still using Oracle 12

What is your driver version?

[MudGuard]

Thanks for the hint - I upgraded from ojdbc6 to ojdbc11, and now it works.

You were completely right in suspecting the driver!

Thanks again,

and a happy easter egg search ;-)

Andreas