Toad 12.11.0.95
A field has odd data in it and Toad does not return any data. Instead it fails with:
an invalid character was found in text content
This does not happen in Toad 12.6
Reproduce is:
select chr(01) from dual;
Is this a bug or a feature?
I do not get an error with your sample query
select chr(01) from dual;
when I use “Execute Statement” mode, but I am able to reproduce the error when I execute the same content using “Execute as Script”.
Should take this one to Support so they can document and log this issue.