Question

4
Replies
781
Views
Sridevi Kakolu (SrideviK9723)
Rowan Companies

Rowan Companies
US
SrideviK9723 Member since 2017 4 posts
Rowan Companies
Posted: January 18, 2018
Last activity: February 6, 2018
Posted: 18 Jan 2018 13:28 EST
Last activity: 6 Feb 2018 8:23 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.