CLOB truncated in report [message #595078] |
Fri, 06 September 2013 03:58 |
kalid
Messages: 8 Registered: September 2008
|
Junior Member |
|
|
Hi.
I am using Report Builder 11g. I want to display (in a report) a CLOB column. But it is truncated at 65535 characters. In the table, the clob is ok.
Any suggestions?
Thanks.
[Updated on: Fri, 06 September 2013 04:44] Report message to a moderator
|
|
|
Re: CLOB truncated in report [message #595417 is a reply to message #595078] |
Wed, 11 September 2013 02:42 |
kalid
Messages: 8 Registered: September 2008
|
Junior Member |
|
|
I found the (a) solution. I created the CLOB with "chr(13)" at the end of every line. Now, I put "chr(10)||chr(13)" and it works. It's true, in the database it doesn't look ok anymore (after every line is an empty line), but in the report (and in the csv) it looks just fine.
|
|
|
|
Re: CLOB truncated in report [message #595420 is a reply to message #595418] |
Wed, 11 September 2013 03:14 |
kalid
Messages: 8 Registered: September 2008
|
Junior Member |
|
|
I don't see any connection either, but it seems there is some.
In Builder, with chr(13), the CLOB was displayed as a continuous line (wrapped to fit the frame) and truncated. In the csv the CLOB was dispalyed ok (every line on a new line), but also truncated.
In Builder, with chr(10), the CLOB was displayed ok: corect and complete. In the csv the CLOB was dispalyed very strange: a few continuous lines, but not truncated.
So, I tried to put both chr-s at the end of the lines and it works!
|
|
|