16.8.1 Handling Temporary Uploaded Files

Use APEX_APPLICATION_TEMP_FILES to stage uploaded images or files before saving them.

To support uploading multiple images or files in a logical flow that can span one or more pages, change the Storage > Type of your Image Upload or File Upload page item to Table APEX_APPLICATION_TEMP_FILES.

• Controlling Retention of Temporary Files
  Control how long uploaded files remain in APEX_APPLICATION_TEMP_FILES before you process them or APEX purges them.
• Referencing Temp Files by Unique Name
  Understand how upload item values identify one or more files in APEX_APPLICATION_TEMP_FILES.
• Displaying Temp File Names and Types
  Show temporary upload file names and readable file types in a report region.
• Processing Temporary Uploaded Files
  Process multiple uploaded files by splitting the upload item’s colon-delimited file name list.
• Deleting Temporary Uploaded Files
  Delete temporary upload files from APEX_APPLICATION_TEMP_FILES when you no longer need them.