Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ErWin triggers and mutating tables
I don't know if you'd call this a modification but I never use the ERwin
triggers. How do you think they will benfit you?
Van
Massimo Gentilini wrote in message <7g6llb$nc6$1_at_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 Thu Apr 29 1999 - 17:10:03 CDT