apex_generate_login
Generate an Oracle APEX login page (page 101) with native or custom PL/SQL authentication, customizable fields and labels.
Instructions
Generate a login page (page 101) with APEX authentication.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | No | Page ID (default 101). Must match the login URL in create_app. | |
| app_name | No | Application name shown above the login form. | |
| page_name | No | Page display name. | Login |
| password_label | No | Label for password field (default "Password"). | Password |
| username_label | No | Label for username field (default "Username"). | Username |
| auth_process_plsql | No | Custom PL/SQL authentication block. If omitted, uses APEX native authentication: "apex_authentication.login(p_username=>:P101_USERNAME, p_password=>:P101_PASSWORD);" For custom auth example: '''DECLARE v_user_id NUMBER; BEGIN SELECT user_id INTO v_user_id FROM app_users WHERE username = LOWER(:P101_USERNAME) AND password_hash = DBMS_CRYPTO.HASH( UTL_RAW.CAST_TO_RAW(:P101_PASSWORD || salt), 3); apex_util.set_session_state('APP_USER_ID', v_user_id); END;''' | |
| login_button_label | No | Login button text (default "Sign In"). | Sign In |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |