Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine whether executing within trigger

Re: How to determine whether executing within trigger

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 28 Nov 2007 13:42:13 -0800
Message-ID: <1196286126.912066@bubbleator.drizzle.com>


michael.young_at_paetec.com wrote:
> 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

I am not aware of any functionality that does this.

-- 
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 Wed Nov 28 2007 - 15:42:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US