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.
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 |