Re: erwin + RI triggers = trouble

Or consider migrating up to the current rev, 4.0.

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:pIWR6.509$bd.147086_at_newshog.newsread.com...
> 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
> always been ERwin's weakest link. Your might take a look at Designer.
>
> Van
>
> "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:41 CEST