Malcolm Dew-Jones wrote:
> I know from experience that at least in
>
> Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
>
> if a column is not included in an update statement and an update trigger
> sets the value of the column then the value provided by the trigger is not
> saved.
>
> For the column value assigned by the trigger to be saved, the update has
> to include the column in the list of columns being set.
>
>
> HOWEVER, I also know that the above is not always true. For example the
> query I am just looking at does not mention the WHEN_UPDATED column, but
> the value set by the trigger _is_ saved.
>
> I am confused.
>
> I wonder where the exact details of what is going on is documented.
>
> If someone could enlighten me I would appreciate it, thanks.
>
> MDJ
I am too. Please write a small demo that demonstrates what it is you are
referring to.
--
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 Wed Aug 01 2007 - 20:59:04 CDT
