Re: How to determine whether executing within trigger

From: Matthias Hoys <anti_at_spam.com>
Date: Wed, 28 Nov 2007 23:38:50 +0100
Message-ID: <474dede6$0$29255$ba620e4c@news.skynet.be>

<michael.young_at_paetec.com> wrote in message news:20d9d88d-1e2b-435d-8d61-c32d19b87408_at_l1g2000hsa.googlegroups.com...
>I vaguely seemed to recall seeing a standard Oracle package / function
> along these lines, but I can't seem to find it now...
> Is there a way to determine whether the current execution is operating
> inside a trigger? There are certain statements (primarily transaction
> control, DDL) that cannot be executed within a trigger (unless there
> in an autonomous transaction routine, at which point they're "outside"
> the trigger context).
> TIA,
> Michael

dbms_application_info ? Received on Wed Nov 28 2007 - 16:38:50 CST