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

Raj,
 The code for the trigger is :
CREATE OR REPLACE TRIGGER INFO 
AFTER LOGON
ON DATABASE 
begin
insert into info 
values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_login_user);
end;
 And I test it by logging into the DB with another user also say a user 
called LOG but no record in the table. Moreover I tried the following sql on 
the prompt also:
 SELECT ORA_CLIENT_IP_ADDRESS FROM DUAL; -- no output
 But when I issued :
 SELECT ORA_LOGIN_USER FROM DUAL; -- gives me the current username logged in 
the DB
 Any idea?????

 On 6/9/05, rjamya <rjamya@xxxxxxxxx> wrote: 
> 
> show us the real code and don't log in as SYS to test.
> 
> Raj
> 
> On 6/9/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote: 
> > 
> > Sorry David,
> > Its a typo error...its not LOGOFF its LOGON... I checked it once again
> > also.
> > On 6/9/05, David Sharples <davidsharples@xxxxxxxxx> 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@xxxxxxxxx> 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@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@xxxxxxxxx
> > onkarnath.tiwary@xxxxxxxxx 
> > 
> > --
> > http://www.freelists.org/webpage/oracle-l
> > 
> 
> 
> 
> -- 
> ------------------------------
> select standard_disclaimer from company_requirements where category = 
> 'MANDATORY'; 
> 



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

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

Other related posts: