Re: How to determine whether executing within trigger

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 29 Nov 2007 08:18:10 -0800
Message-ID: <1196353082.808814@bubbleator.drizzle.com>

Matthias Hoys wrote:

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

How?

Sure you could set a MODULE and ACTION but that isn't what the OP is asking about as I read the question. It is certainly best practice and one not practiced nearly enough. But it is wholly generic.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Nov 29 2007 - 10:18:10 CST