Currently APEX_ZIP.GET_FILE_CONTENT raises
ORA-29294: A data error occurred during compression or uncompression.
when attempting to extract a file from a password protected zip.
Please enhance GET_FILE_CONTENT() so that it can successfully extract content from a password protected zip.
Additionally, it would be useful if ADD_FILE() and FINISH() could be used to create password protected zip files.
Working with password protected zip files.
Preferred Solution (Optional)
P_ZIP_PASSWORD IN VARCHAR2 DEFAULT NULL parameter to all relevant APEX_ZIP subprograms.