apex_add_calendar
Add a calendar region to an Oracle APEX page by providing a SQL query with event date and title columns.
Instructions
Add a calendar region. SQL must include a date column and a title column.
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>",
"sql_query": "<sql_query>",
"date_column": "<date_column>",
"title_column": "<title_column>"
},
"name": "apex_add_calendar"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| sequence | No | Region display order on the page. | |
| sql_query | Yes | SQL query returning event data. Must include at minimum the date_column and title_column. Example: "SELECT DT_AVALIACAO, DS_BENEFICIARIO, DT_FIM FROM TEA_AVALIACOES WHERE DS_STATUS != 'CANCELADA'" | |
| display_as | No | Default calendar view: "month" | "week" | "day" | "list". | month |
| auth_scheme | No | Optional authorization scheme name. | |
| date_column | Yes | Column name for the event start date/datetime. | |
| region_name | Yes | Region title shown in the APEX page. | |
| title_column | Yes | Column name for the event title/label. | |
| end_date_column | No | Optional column for the event end date/datetime. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |