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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center