Kbase 15039: FIND CREATE DELETE and ASSIGN schema triggers in procedures
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
FIND CREATE DELETE and ASSIGN schema triggers in procedures
What is the scope of a schema trigger when it is included in a
procedure rather than on the database?
As long as the procedure that created the schema trigger is still in
the call stack or is still active as a persistent procedure, the
schema trigger will be active. The exception is when a subsequently
called procedure overrides the trigger with another schema trigger
of the same type.
The trigger goes out of scope (i.e., becomes inactive) when the
procedure that created it gets destroyed.
Progress Software Technical Support Note # 15039