packages sess.get_session_db

sess.get_session_db

Repository spec: sess.get_session_db, body: sess.get_session_db

Signature

FUNCTION get_session_db
RETURN sessions.session_db%TYPE;

Show code (17 lines)

FUNCTION get_session_db
RETURN sessions.session_db%TYPE AS
BEGIN
    --
    -- @TODO: explore DBMS_SESSION.UNIQUE_SESSION_ID
    --
    IF recent_session_db IS NULL THEN
        SELECT TO_NUMBER(s.sid || '.' || s.serial#, '9999D999999', 'NLS_NUMERIC_CHARACTERS=''. ''') INTO recent_session_db
        FROM v$session s
        WHERE s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');
    END IF;
    --
    RETURN recent_session_db;
EXCEPTION
WHEN NO_DATA_FOUND THEN
    RETURN NULL;
END;