Oracle trigger if updating then
See tkyte.blogspot.com/2005/08/, tkyte.blogspot.com/2005/08/part-ii-seeing-restart.html, and tkyte.blogspot.com/2005/09/for details on this behavior.) What this means is that any trigger that invokes many of the UTL_ functions is probably doing it wrong.
For example, if you use a trigger to invoke UTL_FILE to write text to a file, that is probably wrong. PUT_LINE calls in a trigger will not roll back; you’ll have written to a file about an event that never happened.
This causes confusion (otherwise, I would not have received the e-mail in the first place! In this system, this NAME attribute was apparently not expected to always be “fname
Well, SMTP (Simple Mail Transfer Protocol) won’t participate in a distributed transaction with Oracle Database, so the sending of the e-mail will not roll back.This name information is derived data based on the values in two other columns.