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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trigger not firing!!!!!!!!!!(URGENT)

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

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 9 Jun 2005 15:20:52 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E6AE@EXCNYSM0A1AJ.nysemail.nyenet>


Rich,

Ummm. I used sys_context in my example. He was asking for stuff that obviously was in v$sessions.

Oh SNAP!

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich
Sent: Thursday, June 09, 2005 3:15 PM
To: Oracle-L (E-mail)
Subject: 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 =3D3D3D USERENV('SESSIONID');

Tom

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 09 2005 - 15:25:55 CDT

Original text of this message

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