DA Morgan wrote:
> FM wrote:
>
>> Also, the 10gR2 documentation indicates that :
>>
>> Restrictions on AFTER Triggers AFTER triggers are subject to the
>> following restrictions:
>> You cannot write either the :OLD or the :NEW value.
>>
>> So you should change the trigger to a BEFORE trigger.
>>
>> FM
>
> Where in the documentation does it say that?
>
<snip>
> 10 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);
> 14 END referencing_clause;
> 15 /
<snap>
> Because it is not correct. Nor do I think it was correct in 8i or 9i and
> possibly long before that.
READ <> WRITE
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/
Received on Tue Aug 22 2006 - 14:25:40 CDT
