Question
HCL Technologies
IN
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.
Accepted Solution
HCL Technologies
IN
IKOR
AU
trying to understand your requirement. If you are updating some profiles (That means where the records are already exists) why you are using an Insert ,not an update? Also why you mentioned without using Obj methods.
HCL Technologies
IN
IKOR
AU
My personal thought is ...1000 records shouldn't be a big impact. Specially if you can take the logic or performing the db operation out from the dropdown onchange. You can capture workgroup on dropdown change and perform the DB operation on a submit or somewhere else if possible. Pega best practice is to tolerate using Obj methods when you are transacting with Pega internal DB.
If you are to use the stored procedure approach I didn't come across a specific way of inserting the BLOB stream since this is always handled by Pega.
Accepted Solution
HCL Technologies
IN