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; > > > -- //www.freelists.org/webpage/oracle-l