13.16 POST_LOGIN Procedure

This procedure performs session registration, assuming the authentication step has been completed. It can be called only from within an Oracle APEX application page context.

Syntax

APEX_CUSTOM_AUTH.POST_LOGIN (
    p_uname         IN VARCHAR2 DEFAULT NULL,
    p_session_id    IN VARCHAR2 DEFAULT NULL,
    p_app_page      IN VARCHAR2 DEFAULT NULL,
    p_preserve_case IN BOOLEAN  DEFAULT FALSE )

Parameter

Table 13-8 POST_LOGIN Parameters

Parameter	Description
p_uname	Login name of user.
p_session_id	Current APEX session ID.
p_app_page	Current application ID and after login page separated by a colon (:).
p_preserve_case	If TRUE, do not include p_uname in uppercase during session registration.

Example

The following example performs the session registration following a successful authentication.

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