GET_LOGIN_USERNAME_COOKIE Function

10.5 GET_LOGIN_USERNAME_COOKIE Function

This function reads the cookie with the username from the default login page.

Syntax

GET_LOGIN_USERNAME_COOKIE (
    p_cookie_name IN VARCHAR2 DEFAULT C_DEFAULT_USERNAME_COOKIE )
    RETURN VARCHAR2;

Parameters

Parameters	Description
`p_cookie_name`	The cookie name which stores the username in the browser.

Example

This example is a part of a "Before Header" process. It populates a text item P101_USERNAME with the cookie value and a switch P101_REMEMBER_USERNAME based on whether the cookie already has a value.

:P101_USERNAME          := apex_authentication.get_login_username_cookie;
:P101_REMEMBER_USERNAME := case when :P101_USERNAME is not null
                           then 'Y'
                           else 'N'
                           END;