Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Session# and SID In a Trigger

Session# and SID In a Trigger

From: B. Alfredo M. Naling, Jr. <someone_at_hotmail.com>
Date: Thu, 3 Oct 2002 16:06:39 +0800
Message-ID: <angthm$m7r$1@reader01.singnet.com.sg>


How do I determine the session serial# and session sid inside a trigger. I know
you can query v$session with a "where username = user" but I don't want this criteria as it is possible that one user is logged on more than once.

Help!!!

cheers,
Alfredo Received on Thu Oct 03 2002 - 03:06:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US