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@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

Other related posts: