ORA-24345: A Truncation or null fetch error occurred
486186Jun 12 2008 — edited Jun 3 2013Hi,
I have a table with a CLOB that contais encoded an compress data.
I'm trying to create a procedure to manipulate that data, to migrate to a new data model, and for that i need to get the data in that column as text, uncompressing and decoding it.
When i do the following query i get the ORA-24345 error.
select UTL_COMPRESS.lz_uncompress(utl_encode.BASE64_DECODE(utl_raw.cast_to_raw(EVENT_BODY)))
from auditing where index__ = 'vitria:665586';
Does anyone know of a way to overcome this error within the PL/SQL code?
Thanks,
Alex da Costa