Re: Trigger problem ADO to ORACLE 8

From: Sean <seanm555_at_comcast.net>
Date: 7 Nov 2006 11:00:51 -0800
Message-ID: <1162926051.075371.209170@h54g2000cwb.googlegroups.com>

Thanks for your response. Yes, I am actually updating the row with the timestamp. How would my code need to change to use the method you suggest? I don't understand why for the owner "ADM" this works and any other user doesn't work. Thanks again,

Sean

Here is the trigger code:

CREATE OR REPLACE TRIGGER "ADM"."LASTMOD" BEFORE UPDATE OF "SCHED_FRI", "SCHED_MON", "SCHED_SAT", "SCHED_SUN", "SCHED_THU", "SCHED_TUE", "SCHED_WED" ON "ADM"."DDATA" FOR EACH ROW begin
  If (:new.SCHED_MON is not null) then
    If (:old.SCHED_MON is null) then
      SELECT sysdate INTO :new.SCH_LAST_MOD from dual;     Else

      If (:new.SCHED_MON <> :old.SCHED_MON) then
        SELECT sysdate INTO :new.SCH_LAST_MOD from dual;
      End if;

    End if;
  Else
    If (:old.SCHED_MON is not null) then       SELECT sysdate INTO :new.SCH_LAST_MOD from dual;     End if;
  End if;
end; Received on Tue Nov 07 2006 - 13:00:51 CST