Where is the commit? ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Onkar N Tiwary Sent: Thursday, June 09, 2005 5:51 AM To: rjamya; oracle-l@xxxxxxxxxxxxx Subject: Re: Trigger not firing!!!!!!!!!!(URGENT) Raj, The code for the trigger is : CREATE OR REPLACE TRIGGER INFO=20 AFTER LOGON ON DATABASE=20 begin insert into info=20 values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_l= ogin_user); end; And I test it by logging into the DB with another user also say a user=20 called LOG but no record in the table. Moreover I tried the following = sql on=20 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=20 the DB Any idea????? On 6/9/05, rjamya <rjamya@xxxxxxxxx> wrote:=20 >=20 > show us the real code and don't log in as SYS to test. >=20 > Raj >=20 > On 6/9/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote:=20 > >=20 > > 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:=20 > > > > hi all, > > > > I have created one trigger on LOGON event which is storing the = ip of=20 > > the > > > > machine making the connection,current date n time and oracle=20 > > username in > > > a > > > > table with the following structure:=20 > > > > 16:15:31 SQL log@TEST35> > CREATE OR REPLACE TRIGGER INFO > > > > BEFORE LOGOFF > > > > ON DATABASE > > > > begin > > > > insert into info > > > > > > >=20 > > = values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_l= ogin_user);=20 > >=20 > > > > >=20 > >=20 > >=20 > > -- > > Thanks & Regards, > > T. Onkar Nath > > Ph : +91-9826728111(Cell) > > to_onkar@xxxxxxxxx > > onkarnath.tiwary@xxxxxxxxx=20 > >=20 > > -- > > //www.freelists.org/webpage/oracle-l > >=20 >=20 >=20 >=20 > --=20 > ------------------------------ > select standard_disclaimer from company_requirements where category = =3D=20 > 'MANDATORY';=20 >=20 --=20 Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@xxxxxxxxx onkarnath.tiwary@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. -- //www.freelists.org/webpage/oracle-l