Oracle, ERWin, RI via triggers and mutating tables ...

From: Aleksey Burdakov <burdakov_at_vesco.ru>
Date: 8 Oct 2001 06:27:19 -0700
Message-ID: <9292180b.0110080527.62f74313@posting.google.com>

Yet another problem in moving from another DBMS to Oracle 8.1.7:

The schema for a DB which is being moved to Oracle, as an example, has two tables A and B. A is B's parent and B is A's child. ERWin has generated triggers to support Referential Integrity (A-Cascade Update, B-Update Restrict), and at the moment of UPTATE of a record in table A
(parent) Oracle throws "Mutating table" error.

Oracle has published "Avoiding Mutating Tables" article
(http://osi.oracle.com/~tkyte/Mutate/index.html) concerning that
question, but the solution is cumbersome.

The questions:
1) Does anybody know if that problem has been solved in Designer/2000 by Oracle or PowerDesigner by Sybase ?
2) Has anyone an experience in writing custom ERWin trigger templates resolving that problem ?

Best Regards,

Aleksey Burdakov

P.S. I am talking of the both ERWin 3.5.2 and 4.0 with the latest SPs. Received on Mon Oct 08 2001 - 08:27:19 CDT