Andy Hassall wrote:
> 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.
Then can you explain the term WRITE in the context of a trigger if it
isn't doing an insert statement. I find this read-write language
terribly confusing (obviously) the way it is being used.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 22 2006 - 18:20:03 CDT
