LOGIN Procedure

Also referred to as the Login API, this procedure performs authentication and session registration.

Syntax

APEX_CUSTOM_AUTH.LOGIN (
    p_uname         IN  VARCHAR2  DEFAULT NULL,
    p_password      IN  VARCHAR2  DEFAULT NULL,
    p_session_id    IN  VARCHAR2  DEFAULT NULL,
    p_app_page      IN  VARCHAR2  DEFAULT NULL,
    p_entry_point   IN  VARCHAR2  DEFAULT NULL,
    p_preserve_case IN  BOOLEAN   DEFAULT FALSE )

Note:

Do not use bind variable notations for p_session_id argument.

Parameter

Table 13-6 LOGIN Parameters

Parameter	Description
`p_uname`	Login name of the user.
`p_password`	Clear text user password.
`p_session_id`	Current Oracle APEX session ID. Do not use bind variable notations for `p_session_id` argument.
`p_app_page`	Current application ID. After login page separated by a colon (:).
`p_entry_point`	Internal use only.
`p_preserve_case`	If `TRUE`, do not include `p_uname` in uppercase during session registration.

Example

The following example performs the user authentication and session registration.

BEGIN
    APEX_CUSTOM_AUTH.LOGIN (
        p_uname       => 'FRANK',
        p_password    => 'secret99',
        p_session_id  => V('APP_SESSION'),
        p_app_page    => :APP_ID||':1');
END;