Re: Mutating problem

From: Ian Stevenson <stevenson_at_nospam.logica.com>
Date: 1997/07/03
Message-ID: <01bc877f$c7202420$4611ea9e@P014330.LOGICA.CO.UK>#1/1

Bala,
Check out an extract from "Oracle Design" (published by O'Reilly and Associates) at www.westmail.demon.co.uk
Ian

Bala Kundumadathil <bbkund_at_searle.monsanto.com> wrote in article <33BACD49.40F8_at_searle.monsanto.com>...
> Hi,
>
> Would appreciate if someone could help me get over the mutating problem
> when using database triggers in Oracle 7.
> What I have is 2 tables A and B. Table B has a foreign key linked to
> table A. When inserting into Table A, I have a DB trigger(after Insert)
> which inserts a detail record into table B. Since B looks up table A, I
> encounter the mutating problem.
>
> If there is no direct approach, what are the ways of getting over this
> hiccup.
>
> Thanks in advance to all your suggestions.
>
> Bala.
>
Received on Thu Jul 03 1997 - 00:00:00 CDT