The following system supported triggers stack functions are useful for analyzing and debugging purposes.
Note The trigger stack refer to those triggers that are cached, regardless of whether they are executed or detected for execution. Trigger stack functions can be used in the application program like any other function.
The functions are:
▪TRIG_COUNT()
This function returns the number of triggers in the trigger stack, including the current trigger. The return value is an integer.
▪TRIG_NAME(n)
This function returns the nth trigger name in the trigger stack. The first trigger position or offset is zero.
▪TRIG_SCHEMA(n)
This function returns the nth trigger schema name in the trigger stack. The first trigger position or offset is zero. The return value is a string.