Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine whether executing within trigger
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.orgReceived on Wed Nov 28 2007 - 15:42:13 CST