Oracle Apex - File (Upload and Download)

Upload Steps

Create a file browse item

  • create a blank page
  • create an HTML region
  • create page item (file browse) named PXX_FILE_NAME
  • set the settings
Settings Description
Value Required If select Yes and the page item is visible, Oracle Application Express automatically performs a NOT NULL validation when the page is submitted
Storage Type Identify where the uploaded file is stored
MIME Type Column Specify the name of the column where the MIME type of the uploaded file should be stored
Filename Column Specify the name of the column where the file name of the uploaded file should be stored
Character Set Column Specify the name of the column where the character set of the uploaded file should be stored
BLOB Last Updated Column Specify the name of the column to update with the current time stamp when a file is uploaded <note warning>The character set of the BLOB is not automatically set on upload. See Apex</note>
Download Link (in case of update)
Display Download Link Select Yes to display the download link next to the Browse button
Download Link Text Text used for the download link
Content Disposition Determines if the downloaded content is displayed inline within the Browser window or if a Open dialog displays

Extra columns DataType

MIMETYPE     VARCHAR2(255),
FILENAME     VARCHAR2(255),
LAST_UPDATE  DATE,
CHARSET      VARCHAR2(128));

Character set

The character set of the BLOB is not automatically set on upload. To store the character set value for your BLOB, you must provide an additional page item on your page which is bound to the column you use to store the character set, and where the user will be able to specify the character set for the document they are uploading.

Get

File

APEX_UTIL.GET_FILE Procedure from the Oracle Application Express file repository.

The APEX_UTIL.GET_FILE_ID Function function obtains the primary key of a file in the Oracle Application Express file repository.

Image

The APEX_UTIL.GET_BLOB_FILE_SRC function gives the ability to more specifically format the display of the image (with height and width tags).

Download

Documentation / Reference


Powered by ComboStrap