I have a zip file that that contains about 40 xml files that need to be loaded, is it possible to upload the zip file through an apex front end then unzip the xml files into a blob table so they can be processed.
Using an apex from end I can load the files individually and process them but as there are many files its time consuming so wondering if the base file i get can be processed in one go i.e. upload the zip file then some how load the contents of each file into a clob.
APEX 5.1 hopefully soon to be 19.1
Thanks in advance