RE: Trigger not firing!!!!!!!!!!(URGENT)
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 14:15:17 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Thursday, June 09, 2005 2:03 PM
To: rweiss@xxxxxx; 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
