16.8.1.1 Controlling Retention of Temporary Files

Control how long uploaded files remain in APEX_APPLICATION_TEMP_FILES before you process them or APEX purges them.

Setting their storage type to Table APEX_APPLICATION_TEMP_FILES makes Image Upload and File Upload items automatically save uploaded files in this table. Its columns appear in the table below.

Table 16-2 APEX_APPLICATION_TEMP_FILES Table Structure

Column Name	Data Type	Description
NAME	VARCHAR2	Unique name of the uploaded file
BLOB_CONTENT	BLOB	Binary content of the file
FILENAME	VARCHAR2	Original file name
MIME_TYPE	VARCHAR2	MIME type of the file
APPLICATION_ID	NUMBER	APEX Application ID
CREATED_ON	DATE	Date and time when file was created

The related Purge Files at setting determines the retention period. Set it to End of Request if you process the uploaded files to permanent storage during the same request that submits them. Set it to End of Session instead to process them later, for example, when the user completes a multi-step process.