Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger not firing!!!!!!!!!!(URGENT)
show us the real code and don't log in as SYS to test.
Raj
On 6/9/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> 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_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
>
-- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2005 - 07:22:46 CDT
![]() |
![]() |