RE: Endless cycle in inserting/updating tables

Jared,

I agree 100%. Fortunately not my design, I was asked for a solution. My thanks to Garry Gillies
for a very simple solution using after insert/update trigger.

Rick

> -----Original Message-----
> From: Jared Still [SMTP:jkstill_at_bcbso.com]
> Sent: Friday, October 13, 2000 2:09 PM
> To: Cale, Rick T (Richard)
> Cc: oracledba_at_quickdoc.co.uk; ORACLE-L_at_fatcity.com
> Subject: Re: Endless cycle in inserting/updating tables
>
>
> Rick,
>
> You need to seriously consider the design of these tables
> and/or this process. It sounds suspect.
>
> Jared
>
> On Fri, 13 Oct 2000, Cale, Rick T (Richard) wrote:
>
> > Hi All,
> > I have 3 tables tab1,tab2,tab3. Each table has a trigger that will
> update or
> > insert the other 2
> > Tab1 when inserting inserts into tab2 and tab3.
> > Tab2 when inserting inserts into tab1 and tab3.
> > Tab3 when inserting inserts into tab1 and tab2
> >
> > As you can see this would result in endless loop.
> >
> > Does anyone have any suggestions on how to solve?
> >
> > Also if a table has a foreign constraint and a before insert/update
> trigger
> > what is done first on insert
> > or update? Is the RI constraint checked first or is the trigger fired
> first.
> > I have a situation if the RI
> > constraint fails I want to insert a record into another table so the
> foreign
> > key constraint does not fail
> >
> > Thanks
> > Rick
> >
> >
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> >
>
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
Received on Sat Oct 14 2000 - 06:12:31 CDT