Question
Rowan Companies
US
Last activity: 6 Feb 2018 8:23 EST
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:
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
Accepted Solution
Pegasystems Inc.
IN
Hello,
Sri sent over the below as the resolution, over a private message to the moderators.
I solved this using connect-sql the clob columns are reading as string values.
Regards,
Pegasystems Inc.
US
What version of Pega are you on? Later versions added support for CLOB columns and limited functionality was backported to some versions.
EPAM Systems, Inc.
ES
Accepted Solution
Pegasystems Inc.
IN
Hello,
Sri sent over the below as the resolution, over a private message to the moderators.
I solved this using connect-sql the clob columns are reading as string values.
Regards,