apex_add_app_item
Create an application-level item to store global variables accessible on every page. Define security protection and optional PL/SQL initialization.
Instructions
Create an application-level item (global variable available on all pages).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item_name | Yes | Item name (uppercase, e.g., "APP_USER_ROLE", "APP_CLINIC_ID"). Convention: prefix with APP_ to distinguish from page items. | |
| protection | No | Security protection level: - "I": Restricted — cannot be set via URL parameter (default, recommended) - "C": Checksum required — can be set via URL with valid checksum | I |
| session_state_function | No | PL/SQL to initialize the item value. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |