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.
Pegasystems Inc.
FR
Hello,
Can you clarify your version of the product please. Is it an exposed property?
Turkiye Finans
TR
Hi MarcLasserre_GCS,
My product version is 7.1.7
PEG
GB
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.
Turkiye Finans
TR
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?