OraFAQ Forum: SQL & PL/SQL » how do I find out my session id

Home » SQL & PL/SQL » SQL & PL/SQL » how do I find out my session id

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how do I find out my session id [message #1409]

Fri, 26 April 2002 11:44

Ivan
Messages: 180
Registered: June 2000

Senior Member

I need to create a function that returnes current user's session id (8i). The following will not compile:

FUNCTION session_id
RETURN NUMBER IS
vSID NUMBER;
BEGIN
SELECT sid
INTO vSID
FROM v$session
WHERE audsid = SYS_CONTEXT ('userenv','sessionid');
RETURN vSID;
END session_id;

because I don't have DBA role or select PRIVS to V_$SESSON.

Thanks in advance

Report message to a moderator