Re: Help with Triggers

On Tue, 22 Aug 2006 15:32:19 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>The original post says:
>You cannot write either the :OLD or the :NEW value.
>
>I posted:
>INSERT INTO audit_log
>11 (o_fname, o_lname, n_fname, n_lname, chng_by, chng_when)
>12 VALUES
>13 (:OLD.fname, :OLD.lname, :NEW.fname, :NEW.lname, USER, SYSDATE);
>
>You responded with:
>READ <> WRITE
>
>Where in my INSERT STATEMENT do you see a READ?

 There's four of them here in the values clause, two from :old, two from :new.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool