packages sess.get_user_id

sess.get_user_id

Repository spec: sess.get_user_id, body: sess.get_user_id

Signature

FUNCTION get_user_id
RETURN sessions.user_id%TYPE;

Show code (11 lines)

FUNCTION get_user_id
RETURN sessions.user_id%TYPE AS
BEGIN
    RETURN COALESCE(NULLIF(
        COALESCE (                                              -- APEX first, because it is more reliable
            SYS_CONTEXT('APEX$SESSION', 'APP_USER'),            -- APEX_APPLICATION.G_USER
            SYS_CONTEXT(sess.app_namespace, sess.app_user_attr),
            sess.app_user
        ),
        tree.dml_tables_owner), tree.empty_user);        
END;