GET_ACCOUNT_LOCKED_STATUS Function

58.37 GET_ACCOUNT_LOCKED_STATUS Function

This function returns TRUE if the account is locked and FALSE if the account is unlocked. Must be run by an authenticated workspace administrator in a page request context.

Note:

This function operates on the native Oracle APEX user accounts repository and is only applicable to applications configured with Oracle APEX Accounts authentication.

Syntax

APEX_UTIL.GET_ACCOUNT_LOCKED_STATUS (
    p_user_name     IN VARCHAR2 )
    RETURN BOOLEAN;

Parameters

Parameter	Description
`p_user_name`	The user name of the user account.

Example

The following example checks if an Oracle APEX user account (workspace administrator, developer, or end user) in the current workspace is locked.

BEGIN
    FOR c1 IN (SELECT user_name FROM apex_users) loop
        IF APEX_UTIL.GET_ACCOUNT_LOCKED_STATUS(p_user_name => c1.user_name) THEN
            HTP.P('User Account:'||c1.user_name||' is locked.'); 
        END IF;   
    END LOOP;
END;