Skip to Main Content
User Logged Version and Patches

User logged as a Developer

APEX PL/SQL
Check whether the user is logged as a developer or not by checking APP_BUILDER_SESSION and apex_application.g_edit_cookie_session_id

Example

BEGIN
    -- Check whether there is an active APEX Builder or Edit Session
    IF coalesce(
            -- Global variable holding the current APEX App Builder session ID 
           apex_application.g_edit_cookie_session_id,
            -- APEX substitution function returning the App Builder session if available
           v('APP_BUILDER_SESSION')                  
       ) IS NULL THEN
       
        RETURN FALSE;   -- No valid session found → return FALSE

    ELSE
        RETURN TRUE;    -- A valid session exists → return TRUE
    END IF;
END;