Before Update trigger is also firing on insert, why?
Posted by:
dean warren
Date: September 28, 2014 05:01AM
I have three tables, A, B and C where A is the parent of B, B is A's child. C is the history of B.
Below is a diagram showing the relationships and multiplicity (not both relationships are identifying).
1 0..*
A ------- B
| 1
|
| 0..*
C
The insert statement for B is of the form
insert into B ... on duplicate key update ...
There is a trigger in B such that before an update it copies the current row on B to C i.e. C is contains the history of B.
The above works create when there is no A. When A relationship is added I find that the trigger is fired twice, both on insert into B and update on B - why?
Thanks in advance.
Subject
Views
Written By
Posted
Before Update trigger is also firing on insert, why?
2546
September 28, 2014 05:01AM
1323
September 28, 2014 05:04AM
1212
September 28, 2014 04:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.