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

You say its a logon trigger, but it it written as a LOGOFF - try logging off first

On 6/9/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
> 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> > 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_l=
ogin_user);

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