Subject Re: mon$call_stack, FK cascade
Author Dmitry Yemanov
05.12.2013 23:38, unordained wrote:

> I'm using an autonomous transaction from inside my trigger to check mon$call_stack
> to see how deeply-nested my current statement is (active statement of current
> transaction).

Very bad idea performance wise.

> Am I crazy? Do the implied triggers that handle cascades not show up in
> mon$call_stack? Only user-defined triggers and procedures?

IIRC, system triggers are not reported there.


Dmitry