-
Notifications
You must be signed in to change notification settings - Fork 1
packages sess.get_session_db
Jan Kvetina edited this page Sep 30, 2020
·
2 revisions
Repository spec: sess.get_session_db
,
body: sess.get_session_db
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;