how to download a zip file which is stored in directory with the button click in oracle apex
I had written a process to call it but throwing the error as syntaxError: Unexpected token 'P', "PK"... is not valid JSON..
Here is my piece of code written in processing:
Lob_loc := bfilename('ABC_DIRECTORY','data file.zip');
OWA_UTIL.MIME_HEADER( 'application/zip', FALSE );
htp.p('Content-Disposition: attachment; filename="'||'data file.zip"');
when others then
raise_application_error(-20002, SQLCODE||' — '||SQLERRM);