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

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Thu, 9 Jun 2005 16:16:30 +0530
Message-ID: <a144e521050609034648dc138a@mail.gmail.com>

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_at_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_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 09 2005 - 06:51:31 CDT