apex_add_notification_region
Add inline notification/alert regions to Oracle APEX pages, with types for info, success, warning, error, optional dismiss button, and conditional display.
Instructions
Add an inline notification/alert (info/success/warning/error) with optional dismiss.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| message | No | Static message text. Use {item_name} for substitution: e.g., "Welcome back, &APP_USER.!" | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page (default 5 = top of page). | |
| dismissible | No | Show X button to close the notification (default True). | |
| message_sql | No | SQL returning a single VARCHAR2 value as the message. If provided, overrides message. Example: "SELECT 'Last login: ' || TO_CHAR(DT_ULTIMO_ACESSO,'DD/MM/YYYY') FROM TEA_USUARIOS WHERE DS_LOGIN = :APP_USER" | |
| region_name | Yes | Internal region name. | |
| condition_item | No | Show notification only when this page item is not null. | |
| notification_type | No | Alert style: - "info": Blue information box (default) - "success": Green success box - "warning": Orange warning box - "error": Red error box | info |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |