Home » Developer & Programmer » Reports & Discoverer » CLOB truncated in report
CLOB truncated in report [message #595078] Fri, 06 September 2013 03:58 Go to next message
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 Go to previous messageGo to next message
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 #595418 is a reply to message #595417] Wed, 11 September 2013 02:47 Go to previous messageGo to next message
Littlefoot
Messages: 19699
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm glad you solved it, but - what does line terminator have to do with truncation on 64Kth character?
Re: CLOB truncated in report [message #595420 is a reply to message #595418] Wed, 11 September 2013 03:14 Go to previous message
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!
Previous Topic: query for report
Next Topic: Runtime Search
Goto Forum:
  


Current Time: Sun Oct 26 02:01:05 CDT 2014

Total time taken to generate the page: 0.04379 seconds