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

Sorry David,
 Its a typo error...its not LOGOFF its LOGON... I checked it once again also.
 On 6/9/05, David Sharples <davidsharples_at_gmail.com> wrote:
>
> 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_login_user);
>

-- 
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