16.8.2.3 Using a Collection to Capture Image Titles

Use a session-scoped collection to store titles for uploaded images by their unique temporary file names.

When the user uploads photos, the APEX engine automatically stores them in the APEX_APPLICATION_TEMP_FILES table. This table is scoped by user session, so the current user only sees files she uploaded in the current session. To collect additional data like a photo title to accompany the uploaded images, use a collection to temporarily store the extra values. Make sure to store the unique uploaded file name in the collection to use as the join column, then add additional property values into other collection columns as needed. This page uses a collection named UPLOADED_PHOTOS to temporarily save the corresponding photo titles, storing:

• Unique uploaded file name in column C001, and
• Photo title in column C002.

Tip:

For more info on working with session-scoped collections, see Using Temporary Collections.