Question

4
Replies
655
Views
SrideviK9723 Member since 2017 4 posts
Rowan Companies
Posted: January 18, 2018
Last activity: February 6, 2018
Closed
Solved

Read CLOB data type column values from oracle using Report definition

Hi All,

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.

Thank you!

Best Regards,

Sri

Reporting System Administration Data Integration
Moderation Team has archived post
Share this page LinkedIn