How To Download One Or More Files In Oracle Apex
Download One Or More Files 1. Create a process declare var_zip blob; begin -- Create/clear the ZIP collection apex_collection . create_or_truncate_collection( p_collection_name => 'ZIP' ); for i in 1.. apex_application . g_f01 . count loop -- Loop through all the files in the database begin for var_file in ( select file_name, blob_content from movie where 1=1 and file_name is not null and id = apex_application . g_f01(i)) 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 . blob_content ); end loop ; exception when no_data_found then -- If there are no files in the database, handle error
