This function returns APEX_APPLICATION.G_INSTANCE global variable. GET_SESSION_ID returns a number.
Syntax
APEX_CUSTOM_AUTH.GET_SESSION_ID RETURN NUMBER;
Example
The following example retrieves the session ID for the current user.
DECLARE
    VAL NUMBER;
BEGIN
    VAL := APEX_CUSTOM_AUTH.GET_SESSION_ID;
END;