Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> a question about ORACLE 7.3.4 an triggers
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 Received on Thu Dec 20 2001 - 08:55:04 CST