Toad World® Forums

An invalid character was found in text content


#1

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?


#2

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.