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