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

Toad for Oracle
1

I'm on Toad 16.3.231.2085 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?

2

You probably have this option checked:

image
image822×754 34.4 KB

3

That worked!

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

Bart

1 Like