apex_add_region
Add a region to an Oracle APEX page, choosing from static, interactive report, chart, or PL/SQL types.
Instructions
Add a region to a page. Types: STATIC, IR (Interactive Report), PLSQL, chart, blank.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| labels | No | Custom label overrides for IR regions. Supported keys: - "no_data_found": Message when query returns no rows (default "No data found.") - "max_row_count": Max row count warning message (default uses APEX #MAX_ROW_COUNT# token) If None, English defaults are used. | |
| page_id | Yes | Page to add the region to. | |
| sequence | No | Display sequence (10, 20, 30...). | |
| template | No | Override region template name. Uses type default if omitted. | |
| attributes | No | Extra template options dict. | |
| source_sql | No | SQL query for ir/chart regions (e.g., "SELECT * FROM my_table"). | |
| grid_column | No | Page layout position: "BODY", "BREADCRUMB_BAR", "AFTER_HEADER", "BEFORE_FOOTER", "AFTER_FOOTER". | BODY |
| region_name | Yes | Display name of the region. | |
| region_type | No | Type of region: - "static": Static HTML content (use static_content param) - "html": Alias for "static" - "ir": Interactive Report (use source_sql param) — best for data grids - "form": Form container (add items with apex_add_item after) - "chart": JET Chart - "plsql": PL/SQL Dynamic Content - "cards": Native Cards region - "list": Native List region - "tree": Native Tree region - "map": Native Map region | static |
| static_content | No | HTML for static regions. | |
| download_formats | No | Colon-separated download format list for IR regions (default "CSV:HTML:XLSX:PDF"). | CSV:HTML:XLSX:PDF |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |