| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trigger not firing!!!!!!!!!!(URGENT)
It doesn't need a commit - in fact, it is invalid if you put one in
there.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yasin Baskan
Sent: Thursday, June 09, 2005 7:58 AM
To: onkarnath.tiwary_at_gmail.com; rjamya; oracle-l_at_freelists.org
Subject: RE: Trigger not firing!!!!!!!!!!(URGENT)
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=3D0D
AFTER LOGON
ON DATABASE=3D0D
begin
insert into info=3D0D
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=3D0D
called LOG but no record in the table. Moreover I tried the following
sql on=3D0D
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=3D0D
the DB
Any idea?????
On 6/9/05, rjamya <rjamya_at_gmail.com> wrote:=3D0D
>=3D0D
>=3D0D
>=3D0D
>=3D0D >=3D0D >=3D0D
--=3D0D
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=3D ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu=3D mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz=3D ve para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina=3D iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da eklerini=3D kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji=3D gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde=3D ya da eklerinde yer alan bilgilerin dogrulugu, butunlugu ve = guncelligi=3D Bankamiz tarafindan garanti edilmemektedir ve bilinen viruslere = karsi=3D kontrolleri yapilmis olarak yollanan mesajin sisteminizde yaratabilecegi=3D zararlardan Bankamiz sorumlu tutulamaz. This message and the files attached to it are under the privacy liability=3D in accordance with the Banking Law and confidential to the use of = the=3D individual or entity to whom they are addressed. This message cannot be=3D copied, disclosed or sold monetary consideration for any purpose. If you=3D are not the intended recipient of this message, you should not copy,=3D distribute, disclose or forward the information that exists in the content=3D and in the attachments of this message; please notify the sender=3D immediately and delete all copies of this message. Our Bank does not=3D warrant the accuracy, integrity and currency of the information=3D transmitted with this message. This message has been detected for = all=3D known computer viruses thence our Bank is not liable for the occurrence of=3D any system corruption caused by this message -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2005 - 08:10:37 CDT
 |
 |