Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Which one is better? Oracel 9i or DB2 7.2??
unless theres a really good reason parent-child to me implies two tables an
referential integrity.
-- Niall Litchfield Oracle DBA Audit Commission UK "The Nomad" <nobody_at_nowhere.com> wrote in message news:5MSA8.396689$K52.64110834_at_typhoon.tampabay.rr.com...Received on Sat May 04 2002 - 11:39:47 CDT
> > > In update triggers, you cannot modify the table that triggered the
> update -
> > > the result will be something they call a "mutating table" error.
> > > The only way around this is to create an extremely complex package of
> > > "trigger helper functions" and copy data into temporary arrays. This
is
> very
> > > painful.
>
> I don't think I stated the issue clearly. You cannot update other rows in
> the table being updated. My issue was as follows:
>
> I have parent-child relationships in a table. So, updating one row results
> in the need to update maybe 10 other rows. You can't do this in Oracle 8i
> because you can't modify a mutating table. During the update process, I
have
> to cache up the changes into arrays. Then, in the after part of the
trigger,
> I process all the child updates. It is VERY painful.
>
> Marc
>
>