RE: Trigger not firing!!!!!!!!!!(URGENT)

For much of that kinda stuff in 9i, you can try the ORA_ public synonyms
(used as a function) like ORA_CLIENT_IP_ADDRESS or the SYS_CONTEXT
function like SYS_CONTEXT('USERENV','OS_USER').

I would think these would probably be easier than spinning through v$session and probably more resistant to DB version changes.

Enjoy!
Rich

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
(LABOR)

Sent: Thursday, June 09, 2005 2:03 PM
To: rweiss_at_mt.gov; Oracle-L (E-mail)
Subject: RE: Trigger not firing!!!!!!!!!!(URGENT)

Rick,

You can always query from v$session to get the other stuff. I use the following in my login trigger and store the results in a login table.

    SELECT UPPER(program) program, username,

           osuser, terminal,
           sys_context('USERENV','IP_ADDRESS') ip_addr
      FROM V$SESSION
      WHERE AUDSID =3D3D USERENV('SESSIONID');

Tom

--
http://www.freelists.org/webpage/oracle-l