From: kay.kanekowski@web.de   
      
   Hi Joe,   
   is this only a typo here "SCHEMA".TRIGGER_NAME" - there is missing " before   
   TRIGGER_NAME.   
      
   i do this and it works:   
      
   create table kk1 ( wert number, LASTMODIFIED date, lastuser varchar2(100));   
      
   CREATE OR REPLACE TRIGGER scott.T1   
   BEFORE INSERT OR UPDATE ON scott.kk1   
   FOR EACH ROW   
   BEGIN   
      :new.LASTMODIFIED := sysdate;   
      :new.LASTUSER     := user;   
   END;   
   /   
      
   regards   
   Kay   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)