16.8.1.4 Processing Temporary Uploaded Files

Process multiple uploaded files by splitting the upload item’s colon-delimited file name list.

Process all uploaded files for the current application using a cursor for loop like the following. Notice it's passing the ':' as the delimiter character to APEX_STRING.SPLIT to process the distinct unique uploaded file names.

for j in (select blob_content, 
                 filename, 
                 mime_type 
            from apex_application_temp_files 
           where application_id = :APP_ID
             and name in (select column_value 
                            from apex_string.split(:P17_IMAGE),':'))) 
loop 
    -- Reference j.mime_type, j.filename, j.blob_content in here 
end loop;