Andy Hassall wrote:
> On Tue, 22 Aug 2006 15:35:57 -0700, DA Morgan <damorgan_at_psoug.org> wrote:
>
>> FM wrote:
>>>>> Where in the documentation does it say that?
>>> It's in the SQL Reference 10g Release 2 (10.2) entry for Create
>>> Trigger
>>>
>>> http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm#SQLRF01405
>> Thank you for the reference. Unless someone can explain to me the
>> difference between INSERT and WRITE ... in the context of this doc
>
> An INSERT is an SQL statement, and not mentioned in the context at all.
>
> The doc says:
>
>>> You cannot write either the :OLD or the :NEW value.
>
> A write is an assignment, to the :new or :old variables, which are PL/SQL
> record types for the row in the table affected.
>
> A before trigger can modify :new to affect the values actually written to the
> row (which appears to be what the OP wants to do). An after trigger cannot,
> it's too late.
>
>> I think the docs are incorrect and have forwarded this thread to
>> the person at Oracle that wrote it for comment.
>
> The docs are fine...
You are correct. This was not what I interpreted when I read the
original post. Now that I can read the doc I understand the intent.
--
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:21:11 CDT
