Re: erwin + RI triggers = trouble

[Quoted] No triggers in an Oracle database? Wait'll the creators of Forms and Reports find out! And to the original poster - in my opinion triggers have [Quoted] always been ERwin's weakest link. Your might take a look at Designer.

Van

[Quoted] "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B172AC2.261F434C_at_exesolutions.com...
> mark wrote:
>
> > Hi,
> > I just started using erwin with oracle 8i and erwin creats triggers
> > that cause oracle to throw the 'mutating ...' error. Oracle complains
> > that the trigger tries to read the table while it is updating (which
> > is illegal in oracle). Why does erwin create 'illegal' code?
> > Markus
>
> Bad design?
>
> You can go in and change the ERWin defaults. Or, better yet, get rid of
> triggers. They really have no place (just to start a holy war) in an
> Oracle database except in very rare circumstances: Use a procedure
> instead.
>
> Daniel A. Morgan
>
Received on Sat Jul 21 2001 - 23:48:35 CEST