ErWin triggers and mutating tables

From: Massimo Gentilini <massimo.gentilini_at_TOGLIMI.formula.it>
Date: Wed, 28 Apr 1999 11:51:41 +0200
Message-ID: <7g6llb$nc6$1@urano.inet.it>

I'm porting a database from SQL Server to Oracle using ErWin and I'm finding a lot of problems because of the way ErWin manages triggers. When I have some relationships the ErWin triggers always generates a "Mutating table" error.

More specifically I have a table with a reference to itself, like

ScriptID (PK)
Includes_ScriptID (FK that references TableID)

is pretty straightforward, I have a list of scripts and a scripts can include one ore more scripts in the same table. The table has a dummy record with ScriptID=0 so that when a Script don't need to include anything it has 0 as Include_ScriptID

Does anybody ever modified the ErWin standard triggers so that they don't give this kind of problems???

Greetings from Italy
Massimo Received on Wed Apr 28 1999 - 04:51:41 CDT