We have a web page where in we display the records from table (one of cloumn is clob) using Oracle query
One of the particular record length is 73244 and its throwing exception
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 73244, maximum: 4000)
We do not wish to truncate to 4000 characters using DBMS_LOB.SUBSTR function.
Is there any way to display the entire contents in SQL ? ( I cannot use PL/SQL as is web page query)