Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 phillip chen (phillipc4345)
Vizient Inc
Pega Consultant
Vizient Inc
US
phillipc4345 Member since 2020 4 posts
Vizient Inc
Posted: Jan 4, 2023
Last activity: Jan 11, 2023
Posted: 4 Jan 2023 16:55 EST
Last activity: 11 Jan 2023 19:19 EST
Closed

Can Pega read a zip file stored in an Oracle Database table?

Can Pega read a zip file stored in an Oracle Database table? Thank you.

***Edited by Moderator: Pooja Gadige to add capability tags***
To see attachments, please log in.
Pega Platform 7.2.2
Pega Cloud
Low-Code App Development
Data Management
Healthcare and Life Sciences
System Architect

Posted: 2 years ago
Posted: 11 Jan 2023 19:19 EST
phillip chen (phillipc4345)
Vizient Inc
Pega Consultant
Vizient Inc
US

@phillipc4345 The file content was stored in a BLOB type in an Oracle database table. I tried to use "Database Table Class Mapping", however, got "Unsupportive Type: BLOB", "Unsupportive Type: CLOB" - please see attached screen, I also tried to manually create a property CONTENT_BLOB with BLOB type, however, there is no BLOB type available-please see attached screen, can we query BLOB type in an Oracle database table? We are on Pega 7.2.2. Any suggests/recommendations/comments will be greatly appreciated. Thank you.

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