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

From: Yasin Baskan <yasbs_at_kocbank.com.tr>
Date: Thu, 9 Jun 2005 14:58:09 +0300
Message-ID: <083667B535F3464CA0DD0D1DAFA4E3760636CC12@camexc1.kfs.local>

Where is the commit?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary Sent: Thursday, June 09, 2005 2:51 PM
To: rjamya; oracle-l_at_freelists.org
Subject: Re: Trigger not firing!!!!!!!!!!(URGENT)

Raj,
 The code for the trigger is :
CREATE OR REPLACE TRIGGER INFO=0D
AFTER LOGON
ON DATABASE=0D
begin
insert into info=0D
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=0D called LOG but no record in the table. Moreover I tried the following sql on=0D
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=0D
the DB
 Any idea?????

 On 6/9/05, rjamya <rjamya_at_gmail.com> wrote:=0D

>=0D

> show us the real code and don't log in as SYS to test.

>=0D

> Raj

>=0D

> On 6/9/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:=0D
> >=0D
> > 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:=0D
> > > > hi all,
> > > > I have created one trigger on LOGON event which is storing the
ip of=0D
> > the
> > > > machine making the connection,current date n time and oracle=0D
> > username in
> > > a
> > > > table with the following structure:=0D
> > > > 16:15:31 SQL log_at_TEST35> > CREATE OR REPLACE TRIGGER INFO
> > > > BEFORE LOGOFF
> > > > ON DATABASE
> > > > begin
> > > > insert into info
> > > >
> > >=0D
> >

values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_ login_user);=0D
> >=0D
> > >
> >=0D
> >=0D
> >=0D
> > --
> > Thanks & Regards,
> > T. Onkar Nath
> > Ph : +91-9826728111(Cell)
> > to_onkar_at_yahoo.com
> > onkarnath.tiwary_at_gmail.com=0D
> >=0D
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=0D

>=0D
>=0D
>=0D

> --=0D
> ------------------------------
> select standard_disclaimer from company_requirements where category =3D=0D
> 'MANDATORY';=0D

>=0D

--=0D
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



Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel=
 ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu=
 mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz=
 ve para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina=
 iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da eklerini=
 kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji=
 gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde=
 ya da eklerinde yer alan bilgilerin dogrulugu, butunlugu ve guncelligi=
 Bankamiz tarafindan garanti edilmemektedir ve bilinen viruslere karsi=
 kontrolleri yapilmis olarak yollanan mesajin sisteminizde yaratabilecegi=
 zararlardan Bankamiz sorumlu tutulamaz.

This message and the files attached to it are under the privacy liability=
 in accordance with the Banking Law and confidential to the use of the=
 individual or entity to whom they are addressed. This message cannot be=
 copied, disclosed or sold monetary consideration for any purpose. If you=
 are not the intended recipient of this message, you should not copy,=
 distribute, disclose or forward the information that exists in the content=
 and in the attachments of this message; please notify the sender=
 immediately and delete all copies of this message. Our Bank does not=
 warrant the accuracy, integrity and currency of the information=
 transmitted with this message. This message has been detected for all=
 known computer viruses thence our Bank is not liable for the occurrence of=
 any system corruption caused by this message
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 09 2005 - 08:02:16 CDT