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

In out system the trigger is defined with: pragma autonomous_transaction and I do commit.
Anyway, problems with triggers appears in the alert log and in trace files on the server.
(oracle 9.2.0.5 on windows 2000.)

Adar Yechiel
Rechovot, Israel

Onkar N Tiwary wrote:

>hi all,
> I have created one trigger on LOGON event which is storing the ip of the
>machine making the connection,current date n time and oracle username in a
>table with the following structure:
> 16:15:31 SQL log_at_TEST35> desc info
>Name Null? Type
>----------------------------------------- --------
>----------------------------
>IP NOT NULL VARCHAR2(40)
>LOG_DATE NOT NULL DATE
>ORAUSER NOT NULL VARCHAR2(20)
> , but its not working. Dont know where is the error????
> Can anyone plz. suggest me how to do this?????
>CREATE OR REPLACE TRIGGER INFO
>BEFORE LOGOFF
>ON DATABASE
>begin
>insert into info
>values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_login_user);
>
>end;
>
>
>

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