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

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


--
http://www.freelists.org/webpage/oracle-l

Other related posts: