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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"page_id": "<page_id>",
"region_name": "<region_name>",
"item_name": "<item_name>",
"label": "<label>",
"table_name": "<table_name>",
"pk_item": "<pk_item>",
"blob_col": "<blob_col>",
"filename_col": "<filename_col>",
"mimetype_col": "<mimetype_col>"
},
"name": "apex_add_file_upload"
}
}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 |