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
|
|
