ORA-24345: A Truncation or null fetch error occurred in report definition
Hi All,
I have a text value property. It is greater than 4000 characters. I want to show this text value on the report definition but I get this error message "An error occured on executing the query for the report definition - There was a database problem when performing an RDBExecute: code: 24345 SQLState: 99999 Message: ORA-24345: A Truncation or null fetch error occurred ".
Could you help me? please.
Hi MarcLasserre_GCS,
My product version is 7.1.7
I assume it's a non exposed column and it's probably using the PR_READ_FROM_STREAM to try to retrieve the value from the blob.
But the PR_READ_FROM_STREAM is only designed to return a varchar2. And the upper limit of varchar2 is 4000 which probably explain why you're getting the ORA error.
I understood. Probably this is my problem. So, I have a too big data and I want to to show on the report definition. what can I do?
Hello,
Can you clarify your version of the product please. Is it an exposed property?