16 Uploading, Viewing, and Downloading Files

Use Image Upload for images, File Upload for other file types, and native download features to serve stored files.

Use an Image Upload page item to let end users submit one or more images to store in a BLOB column or an Oracle Cloud Infrastructure (OCI) object bucket. This component provides image-specific options like cropping and client-side scaling to avoid multi-megapixel images from modern smartphones if the task doesn't require that resolution

To handle other file types – for example PDF – use the more general File Upload page item. It offers similar single and multiple file abilities for any kind of file.

Your pages can include a native Download dynamic action or page process to declaratively download images or other files, and a page can serve inline images or files using the DOWNLOAD procedure in the APEX_HTTP package.

• Reviewing Break Room and Referrals Pages
  Explore two Woods HR use cases: sharing employee photos and submitting candidate CVs for open position referrals.
• Storing Employee ID in an Application Item
  Populate an application item at login to reuse a session-specific value throughout the app.
• Uploading an Image to a BLOB Column
  Use an Image Upload page item to let users provide a photo or image file to your app.
• Displaying BLOB Column Images
  Display images from a URL or BLOB column in common APEX regions, with a special approach for Interactive Grid.
• Uploading a File to a BLOB Column
  Use a File Upload page item to let users provide a file to your app. When you use it as part of a Form region, the combination automates creating, editing, and deleting the row with the file BLOB column.
• Previewing BLOB Column PDF Files Inline
  To preview a PDF file stored in a BLOB column, use an iframe.
• Downloading a File for Offline Use
  Use the native Download page process or dynamic action to let the user download a file for offline use.
• Uploading Multiple Images or Files
  Your apps can use native temporary storage of uploaded files to support any business requirement.
• Using an OCI Object Bucket for Files
  Use an OCI object bucket to store application files outside your transactional database.