Read CLOB data type column values from oracle using Report definition
We have a requirement to read comma separated large text from oracle data base table clob data type column. I have mapped data base clob columns to Text type properties and i created a report definition to read those column values. When i ran the report definition i am getting below error:
An error occured on executing the query for the report definition - There was a database problem when performing an RDBExecute: code: 22835 SQLState: 99999 Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 8359, maximum: 4000)
DatabaseException caused by prior exception: java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 8359, maximum: 4000)
| SQL Code: 22835 | SQL State: 99999
Query generated by Report definition as below:
SELECT to_char(clobtype_cloumn) FROM oracle_table1;
Please suggest if any one solves this kind of issue.