Sunday, January 29, 2012

Statement level constraint consistency

In the past week I've been investigating how Oracle fires triggers with the Merge and Multi-Table-Insert statements. Also took a look at 'statement-level constraint consistency' with these two types of statements. My findings are here:

Normal transmission on harmful triggers should resume shortly.


  1. This comment should go onto
    but I would need a google account for that and don't intend to get one

    ...So it's a bug if you ask me....
    ... Bug or feature? Definitely a bug IMHO...

    Do you intend to contact Support on this ?

  2. I intend to, yes.
    Just need to find a slot of free time to do so.