Arun kumar (Arunk138)
HCL Technologies

HCL Technologies
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: November 21, 2017
Last activity: November 23, 2017
Posted: 21 Nov 2017 8:17 EST
Last activity: 23 Nov 2017 0:40 EST

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.