Dbms_output for chr(09) and chr(10) won't output tab/LF

I'm on Toad and I've noticed a difference in the output from dbms_output().

In Toad 12, dbms_output.put_line(chr(09)||'Tabbed text') would output a line with leading spaces (a tab). This also works in sqlplus.

In Toad 16, the leading spaces are not displayed.

Similarly, using dbms_output.put_line (chr(10)||'Output after a blank line') to insert a blank line before the message works in Toad 12 (and sqlplus) but doesn't work in Toad 16.

Anybody know what's happening?

You probably have this option checked:

That worked!

Thanks, John. I thought there might be a setting!


1 Like