Skip to main content

Question

 Ferdinand Alvis Kumara (FerdinandAlvisK)
PT Kynerja Abadi Solusindo

PT Kynerja Abadi Solusindo
ID
FerdinandAlvisK Member since 2021 4 posts
PT Kynerja Abadi Solusindo
Posted: Apr 5, 2024
Last activity: Apr 12, 2024
Posted: 5 Apr 2024 3:26 EDT
Last activity: 12 Apr 2024 12:27 EDT
Solved

RDB List can't retrieve CLOB type data

Hi All,

As per these article, PEGA 8.7 or above no longer support CLOB type data on RDB-List

https://docs.pega.com/bundle/platform-88/page/platform/reference/rules/connect-sql-form-data-mapping.html

https://docs-previous.pega.com/reference/87/more-about-connect-sql-rules

Any idea how to retrieve CLOB data from Database?

Because our existing application use RDB-List to retrieve CLOB data on 8.3, and now after we upgrade to 8.8 we can't retrieve CLOB Type Data

Thanks in advance

***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform
Data Model
Installation and Deployment
Data Integration
Insurance
System Architect

  • Reply

Accepted Solution

Posted: 9 months ago
Updated: 9 months ago
Posted: 5 Apr 2024 4:02 EDT
Updated: 12 Apr 2024 12:27 EDT
Srijita Banerjee (SrijitaB)
Maantic Technologies Pvt Ltd.
Srijita Banerjee
Maantic Technologies Pvt Ltd.
IN

Hi @FerdinandAlvisK,

Please go through the following links for further information:

1) https://support.pega.com/discussion/retrieval-clob-data-prpc

2) https://support.pega.com/question/reading-clob-data-using-report-definition

3) https://community.pega.com/support/support-articles/error-ora-22835-when-executing-query-report-definition-0

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice