*** Please Follow My Blog to Inspire Me More Posting. ***
Step 1. Create a Classic Report and add a checkbox
------------------------------------------------------------
SELECT
ID,
APEX_ITEM.display_and_save (02,ID)ID,
FILE_NAME,
FILE_MIMETYPE,
FILE_CHARSET,
FILE_LASTUPD_DTTM,
FILE_UPLOAD_DATE,
FILE_UPLOAD_STATUS,
apex_item.checkbox(01,'#ROWNUM#') CheckBox
FROM TABLE
WHERE 1=1 AND
ID=:P5_ID;
Step 2. Create a process
--------------------------------
declare
var_zip blob;
var number ;
begin
-- Create/clear the ZIP collection
apex_collection.create_or_truncate_collection(
p_collection_name => 'ZIP');
if APEX_APPLICATION.G_F01.COUNT < 1 then
raise_application_error(-20001,'Please Select to Download!');
end if;
for i in 1..APEX_APPLICATION.G_F01.COUNT loop -- Loop through all the files in the database
var:=APEX_APPLICATION.G_F01(i);
begin
for var_file in (select FILE_BLOB , FILE_NAME
from TABLE
where 1=1
AND ID=UPPER(APEX_APPLICATION.G_F02(var)))
loop
-- Add each file to the var_zip file
apex_zip.add_file(
p_zipped_blob => var_zip,
p_file_name => var_file.FILE_NAME,
p_content => var_file.FILE_BLOB );
end loop;
exception when no_data_found then
-- If there are no files in the database, handle error
raise_application_error(-20001, 'No Files found!');
end;
end loop;
-- Finish creating the zip file (var_zip)
apex_zip.finish(
p_zipped_blob => var_zip);
-- Add var_zip to the blob column of the ZIP collection
apex_collection.add_member(
p_collection_name => 'ZIP',
p_blob001 => var_zip);
end;
Step-3 Create a Ajax Callback Process with this name ---download_zip_file
------------------------------------------------------------------------------------------------------
declare
var_mimetype varchar2(50) := 'application/zip';
var_name varchar2(100) := to_char(current_date, 'DD-MON-YYYY') || '_File.zip';
var_blob blob;
begin
-- Get the BLOB from the ZIP collection
select blob001 into var_blob from apex_collections where collection_name = 'ZIP' and seq_id = 1;
sys.htp.init;
sys.owa_util.mime_header( var_mimetype, FALSE );
sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( var_blob));
sys.htp.p('Content-Disposition: attachment; filename="' || var_name || '"' );
sys.htp.p('Cache-Control: max-age=3600'); -- tell the browser to cache for one hour, adjust as necessary
sys.owa_util.http_header_close;
sys.wpg_docload.download_file( var_blob );
apex_application.stop_apex_engine;
apex_collection.truncate_collection(p_collection_name => 'ZIP');
exception when apex_application.e_stop_apex_engine then
NULL;
end;
Step 4. Create a Branche on After Processing
---------------------------------------------------------------
Target-> Type-> Page in this application
page -> same page 5
Advanced-> Request-> APPLICATION_PROCESS=download_zip_file -- download_zip_file is the Ajax Callback process (Name must be same)
.png)
