I'm using the Toad Reports on a query that contains CLOB data. In the reports though, the data in the CLOB are word wrapped with no spaces or new lines like how it's stored in the database.
For example, the data in the CLOB is stored as such:
1234 This is a comment 01/01/2012
4567 Another comment 02/01/2012
8910 Final line 05/05/2012
However in the report generated, the data displays as such:
1234 This is a comment 01/01/20124567 Another comment 02/01/20128910 Final line 05/05/2012
(No spaces nor any carriage returns.)
Is there a way to get the field to show like it does in Data Grid and keep the formatting stored in the CLOB?
Waiting for a fix in a future release of Toad for Data Analysts.