Re: I must get ID session, help me !!

If 8i and above then take a look at v$mystat, v$session , v$transaction.

Those should help.

HTH GovindanK

>
> I can't get ID current session and others info: User Name, User ID, Date,
> Time of session & transaction from Trigger.
>
> Please help me: [EMAIL PROTECTED] or [EMAIL PROTECTED]
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).