I support an Oracle database (Version 19.28.0.0.0) on a Linux box. All the code is in PL/SQL.
There is a table that stores zip files that contain XML file(s) and put them in a BLOB. Is there a way to update the BLOB to change a value in each XML file? I have over 4500 of these BLOBs to deal with. I've found how to modify XML but not in a zip file. I really don't want to download, extract, change, rezip, and submit each one if I can avoid it. Thank you in advance.,