apex_create_app
Creates a new Oracle APEX application and starts an import session. Configure app ID, name, authentication, theme, and more; finalize with apex_finalize_app().
Instructions
Create a new APEX app and start an import session. Call apex_finalize_app() when done.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| app_id | Yes | Numeric application ID (e.g., 200). Must not conflict with existing apps. | |
| schema | No | Database schema owner (from APEX_SCHEMA env var). | APEX_230100 |
| app_name | Yes | Display name shown in the APEX header (e.g., "My App"). | |
| language | No | Application primary language code (default: "en"). Common values: "en" (English), "pt-br" (Brazilian Portuguese), "es" (Spanish), "fr" (French), "de" (German). | en |
| app_alias | No | URL alias (e.g., "MY-APP"). Auto-generated from app_name if omitted. | |
| auth_type | No | Authentication scheme type. Options: - NATIVE_APEX_ACCOUNTS (default): APEX user accounts - NATIVE_CUSTOM_AUTH: custom PL/SQL function - NATIVE_DAD: Database Access Descriptor - NATIVE_LDAP: LDAP directory | NATIVE_APEX_ACCOUNTS |
| home_page | No | Page ID for the home/dashboard (default 1). | |
| login_page | No | Page ID for the login page (default 101). | |
| date_format | No | Oracle date display format (default: "DD/MM/YYYY"). Common values: "MM/DD/YYYY" (US), "DD/MM/YYYY" (EU/BR), "YYYY-MM-DD" (ISO). | DD/MM/YYYY |
| theme_style | No | Universal Theme 42 visual style. Options: - "REDWOOD_LIGHT": Modern Oracle Redwood design (default) - "VITA": Classic Vita style (light, clean) - "VITA_SLATE": Vita with dark navigation - "VITA_DARK": Full dark theme - "SUMMIT": Summit style | REDWOOD_LIGHT |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |