Re: a question about ORACLE 7.3.4 an triggers

In article <1008859929.367489_at_newsreader1.wirehub.nl>, "Rob says...
>
>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'
>

If you get this error with 7.1+, it is almost certainly because you have not set the COMPATIBLE parameter in init.ora to 7.1.0 or higher.

multiple same type triggers were added in 7.1...

>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
>
>
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp