What Codes Are Passed in TRIG_OPER to the Trigger?
When a trigger function is invoked it can access field TRIG_OPER to determine what operation was in progress when it was invoked.
The values passed in TRIG_OPER are:
Operation In Progress | Value In TRIG_OPER |
Before Open |
BEFOPN |
After Open |
AFTOPN |
Before Close |
BEFCLS |
After Close |
AFTCLS |
Before Read |
BEFRED |
After Read |
AFTRED |
Before Insert |
BEFINS |
After Insert |
AFTINS |
Before Update |
BEFUPD |
After Update |
AFTUPD |
Before Delete |
BEFDLT |
After Delete |
AFTDLT |