Re: Trigger not firing!!!!!!!!!!(URGENT)
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: onkarnath.tiwary@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 09 Jun 2005 21:31:35 +0800
Check if you've {mistakenly} set
_sys_trig_enabled=FALSE
in your instance's init.ora or spfile.ora.
Hemant
At 07:51 PM Thursday, Onkar N Tiwary wrote:
>Raj,
> The code for the trigger is :
>CREATE OR REPLACE TRIGGER INFO
>AFTER LOGON
>ON DATABASE
>begin
>insert into info
>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
>called LOG but no record in the table. Moreover I tried the following sql on
>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
>the DB
> Any idea?????
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
Other related posts:
