I am getting error ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4918, maximum: 4000) on executing below query (both in hibernate and sql editor).
UPDATE TABLE set COLUMN = UNISTR(COLUMN) WHERE ID = ID;
COLUMN is of type NCLOB
I have tried to use TO_CLOB(UNISTR(COLUMN)) and it didn't work for me.
How can I get rid of this?
PN: I am using Oracle 10.x and Hibernate 3.5.x
I have gone through http://www.dba-oracle.com/t_convert_blob_varchar_datatype.htm. However, I am not able to understand how I can do something similar with UPDATE statement and UNISTR function.