Trigger not firing!!!!!!!!!!(URGENT)

From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 9 Jun 2005 16:16:30 +0530

hi all,
 I have created one trigger on LOGON event which is storing the ip of the 
machine making the connection,current date n time and oracle username in a 
table with the following structure: 
 16:15:31 SQL log@TEST35> desc info
Name Null? Type
----------------------------------------- -------- 
----------------------------
IP NOT NULL VARCHAR2(40)
LOG_DATE NOT NULL DATE
ORAUSER NOT NULL VARCHAR2(20)
 , but its not working. Dont know where is the error????
 Can anyone plz. suggest me how to do this?????
CREATE OR REPLACE TRIGGER INFO
BEFORE LOGOFF 
ON DATABASE 
begin
insert into info 
values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_login_user);

end;
 
-- 
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx

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

Follow-Ups:

Re: Trigger not firing!!!!!!!!!!(URGENT)
From: David Sharples

Re: Trigger not firing!!!!!!!!!!(URGENT)
From: Yechiel Adar

Trigger not firing!!!!!!!!!!(URGENT)

Other related posts: