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

From: <jo_holvoet_at_amis.com>
Date: Thu, 09 Jun 2005 12:53:29 +0200
Message-id: <OF7CDF68F6.11F247AA-ONC125701B.003BC389@eu.amis.com>

Well, you say it's a LOGON trigger but the code you posted says it's a LOGOFF trigger. Which is it ?

mvg/regards

                                                                                                                                         
                      Onkar N Tiwary                                                                                                     
                      <onkarnath.tiwary@         To:      oracle-l_at_freelists.org                                                         
                      gmail.com>                 cc:                                                                                     
                      Sent by:                   Subject: Trigger not firing!!!!!!!!!!(URGENT)                                           
                      oracle-l-bounce_at_fr                                                                                                 
                      eelists.org                                                                                                        
                                                                                                                                         
                                                                                                                                         
                      06/09/2005 12:46                                                                                                   
                      Please respond to                                                                                                  
                      onkarnath.tiwary

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 09 2005 - 07:54:11 CDT