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;