Re: Trigger not firing!!!!!!!!!!(URGENT)
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: David Sharples <davidsharples@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 9 Jun 2005 16:25:06 +0530
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
