Hi,
We need to merge multiple CSV files into a single ZIP file using the APEX_ZIP.ADD_FILE procedure. Since this procedure only accepts BLOB content, we first store the CSV data in a CLOB and then convert it to a BLOB using the APEX_UTIL.CLOB_TO_BLOB function, specifying AL32UTF8 the character set. We also tested with the WE8ISO8859P1 character set. Additionally, we need to encode the file content in Base64 format for use in a REST call body.
However, I’m getting two different Base64 outputs when following these steps and manually performing the process. Am I missing something in the CLOB-to-BLOB conversion, such as specifying the correct character set?
Regards,
Jitendra Tulugu.