Re: Which one is better? Oracel 9i or DB2 7.2??

"The Nomad" <nobody_at_nowhere.com> wrote in message news:<5MSA8.396689$K52.64110834_at_typhoon.tampabay.rr.com>...
>
> 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

Oh I'm sorry, I thought I misunderstood, the answer did seem too obvious.

I would say though that if you are designing an application that requires this type of logic, I would put it in packaged stored procedures, where you don't have these kinds of problems, and have those called to issue the updates. I mostly use triggers for low level stuff, primary keys, time stamps etc.

I understand this isn't always possible when you need to co-exist in an environment with lots of different processes and applications inserting and updating by issuing straight SQL to the database. But then you're in a bit of a mess to begin with, so I'm not really surprised that things could get difficult.

Anyway it sounds like you found the solution despite the challenges, good luck.

Martin Received on Sun May 05 2002 - 11:19:46 CDT