Oracle APEX REPORT ERROR ORA-22835 Buffer too small for CLOB
orton607Apr 12 2010 — edited Mar 10 2011Hello,
Can anyone please help me out with this issue. I think oracle APEX report cannot handle CLOB fields. I have a normal report with an editable textarea field for CHF_DOCUMENT_TEXT whose datatype is CLOB. Below is source query of the report. I am not able to understand the exact problem with the report. Its giving me an error saying
report error:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 5158, maximum: 4000)
Select apex_item.hidden(04,CHF_DOCUMENT_ID,'','f04_' || ROWNUM)
|| APEX_ITEM.MD5_HIDDEN(45,CHF_DOCUMENT_TEXT)
|| APEX_ITEM.HIDDEN(01,ROWNUM,'','f01_' || ROWNUM) " ",
APEX_ITEM.textarea(13,CHF_DOCUMENT_TEXT,20,150,NULL,'f13_' || ROWNUM) DOCUMENT_TEXT,
CHF_UPDATE_DT,
CHF_UPDATE_SID
from TBL_NAMEwhere CHF_DOCUMENT_ID = :P0_DOCUMENT
order by chf_update_dt desc
Can anyone please sort it out.
Thanks,
Orton.