apex_add_file_upload
Add a file upload field to an Oracle APEX page. Configure an after-submit process to store the uploaded file as a BLOB in a database table.
Instructions
Add a FILE_BROWSE item + after-submit process to store uploads as BLOB.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| label | Yes | Display label for the file-browse field. | |
| page_id | Yes | Page ID. | |
| pk_item | Yes | Full page item name (or suffix) for the primary key of the row to update (e.g., ``P10_ID``). Auto-prefixed with ``P{page_id}_`` if needed. | |
| blob_col | Yes | BLOB column name in ``table_name``. | |
| sequence | No | Display sequence for the FILE_BROWSE item. | |
| item_name | Yes | Item name suffix — auto-prefixed with ``P{page_id}_``. | |
| table_name | Yes | Database table that contains the BLOB column. | |
| region_name | Yes | Name of an existing region to place the file-browse item in. | |
| filename_col | Yes | VARCHAR2 column that stores the original filename. | |
| mimetype_col | Yes | VARCHAR2 column that stores the MIME type. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |