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 -> How to determine whether executing within trigger

How to determine whether executing within trigger

From: <michael.young_at_paetec.com>
Date: Wed, 28 Nov 2007 09:56:11 -0800 (PST)
Message-ID: <20d9d88d-1e2b-435d-8d61-c32d19b87408@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 Received on Wed Nov 28 2007 - 11:56:11 CST

Original text of this message

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