Mutating problem

From: Bala Kundumadathil <bbkund_at_searle.monsanto.com>
Date: 1997/07/02
Message-ID: <33BACD49.40F8@searle.monsanto.com>#1/1

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 Wed Jul 02 1997 - 00:00:00 CDT