Re: Trigger not firing!!!!!!!!!!(URGENT)
- From: rjamya <rjamya@xxxxxxxxx>
- To: onkarnath.tiwary@xxxxxxxxx
- Date: Thu, 9 Jun 2005 07:17:46 -0400
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
//www.freelists.org/webpage/oracle-l
Other related posts:
