16.8.1.5 Deleting Temporary Uploaded Files

Delete temporary upload files from APEX_APPLICATION_TEMP_FILES when you no longer need them.

When the Purge Files at retention period ends, temporary files are automatically deleted. However, to eagerly delete them, use any form of SQL DELETE command against the APEX_APPLICATION_TEMP_FILES table. For example, to delete:

• All temp files in the session:

  delete from apex_application_temp_files;

• Just files for current application page's upload item:

  delete from apex_application_temp_files
   where application_id = :APP_ID
               and name in (select column_value 
                              from apex_string.split(:P17_IMAGE),':'));