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.

Related content:

Related content has not currently been identified for this post.

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