Oracle trigger inserting or updating
Trigger names do not need to be unique with respect to other schema objects, such as tables, views, and procedures.
For example, a table and a trigger can have the same name (however, to avoid confusion, this is not recommended).
I seem to remember that there is a variable that gets set to values like 'UPD", 'INS' and 'DEL' when a trigger fires.
What is that variable called and how is it accessed in a trigger.
Include a counter variable in your package to detect this situation.
A relational database does not guarantee the order of rows processed by a SQL statement.
This statement can be used with any interactive tool, such as SQL*Plus or Enterprise Manager.The statements in the trigger body operate under the privilege domain of the trigger owner, not the privilege domain of the user issuing the triggering statement (this is similar to the privilege model for stored subprograms).