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 |