Re: a question about ORACLE 7.3.4 an triggers

On Thu, 20 Dec 2001 15:55:04 +0100, "Rob van der Leer" <rleer_at_lnm.nl> wrote:

>Hi,
>
>We have something strange.
>A customer of us has an Oracle 7.3.4. running on NT 4. We have a SQL script
>that creates tables, triggers a.s.o.
>
>Now we have one table which has MORE THAN ONE trigger. We've installed this
>table in about 85 Oracle's (from version 7.x to 8.1.7) with no problem.
>Even in a test Oracle 7.3.4 (which we have at our office) it is no problem.
>
>The problem is that we have problems with creating more than one trigger
>(for one table) in our customers database.
>
>The problem is documented by Oracle. It simply says: you cannot create more
>than one trigger on the same table
>
>This is the exacte error:
>
>ORA-04090: 'TC_CHK_EDUD_INSTR_ID' specifies same table, event and trigger
>time as 'TC_CHK_EDUD_ROOM_ID'
>

>How can it be that it is accepted by our 7.3.4 version (and all other db's),
>and not by this particular customer 7.3.4 version???
>
>I know I can solve it by creating one big trigger, but that's not the
>question. I want to know WHY, and not how to solve it by creating other
>triggers.
>
>Thanks in advance,
>
>Rob van der Leer
>
>
>
>

There have been a few upgrades to 7.3.4. By one of the upgrades the restriction was removed. However, Oracle still does *NOT* guarantee any particular order in which the 2 triggers will fire. If your customer has 7.3.4.0.0, the restriction will still exist. Don't ask me *when exactly, in which version* this happened, I don't remember.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Dec 20 2001 - 09:45:53 CST