Question

4
Replies
1637
Views
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: 2 years ago
Last activity: 2 years 11 months ago
Closed
Solved

How to update blob column

We have a requirement to update profile for bulk users (worst case 1k operator id) in single shot, so we have designed Stored Procedure to update the list of operator by passing as parameter and insert using insert query. While doing insert, the Blob column (pzpvstream) is updating as Null. So when the instance is handle using Obj-open-By-handle/ Obj-Open, it throws error as Java.ArrayOutOfbound exception because the blob column (pzpvstream) is Null and both of the methods fetches records from pzpvstream (blob column). So, can someone tell any possible ways to update the Blob column in insert query (Outside Pega - In Stored Procedure) or from Pega (without Obj-Open/ Obj-Open-By-Handle method)? Advance thanks for your valuable response.

Data Integration Java and Activities Data Integration
Moderation Team has archived post
Share this page LinkedIn