Creating zip file using cloud utility, OCI Object Storage
I am facing an issue in my OIC integration while trying to create a ZIP file from a CSV stored in OCI Object Storage. Below are the steps followed:
I generated a CSV file (~80 MB) and stored it in an OCI Object Storage bucket using the DBMS_CLOUD.EXPORT_DATA utility.
Downloaded the file from Object Storage into OIC using the "Download file" operation.
Attempted to ZIP the file using the Stage File action.
The ZIP operation failed at the Stage File action not supporting direct ZIP on files referenced from Object Storage.
If I attempt to read this large file (>50 MB) within OIC using the Stage File read operation, in chunks and write the content back into a new file just to create a ZIP, which is time-consuming and inefficient.