Update with Triggers

From: loki <lokino_at_virgilio.it>
Date: Thu, 09 Oct 2003 21:31:53 GMT
Message-ID: <dtkhb.192429$hE5.6509088@news1.tin.it>

Hi all, I have a question about the Oracle's triggers. I wish to store in a field called 'lastUpdate' the sysDate in which the specific row has been modified. I wish to do that with triggers, but I have noticed that a command like

    [...]
    IF UPDATING THEN
        :new.lastUpdate := sysDate;
    END IF; doesn't work and it raises a trigger exception during update ... anyone has tried something like this? Received on Thu Oct 09 2003 - 16:31:53 CDT