apex_add_interactive_grid
Add an interactive grid to an Oracle APEX page to edit database table records, including inline cell editing and row insertion.
Instructions
Add an Interactive Grid (editable spreadsheet). Supports inline editing + add row.
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>",
"table_name": "<table_name>"
},
"name": "apex_add_interactive_grid"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| add_row | No | Show "Add Row" button for inserting new records (default True). | |
| page_id | Yes | Target page ID. | |
| editable | No | Allow inline cell editing (default True). | |
| sequence | No | Region display order. | |
| sql_query | No | SELECT SQL for the IG. If omitted, uses SELECT * FROM table_name. | |
| table_name | Yes | Database table for DML operations (INSERT/UPDATE/DELETE). | |
| auth_scheme | No | Authorization scheme name. | |
| region_name | Yes | Region display name. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |