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: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 28 Nov 2007 19:20:20 +0100
Message-ID: <fikg0l$1cs$2@news4.zwoll1.ov.home.nl>


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

who_called_me, perhaps?
Search asktom.oracle.com

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Nov 28 2007 - 12:20:20 CST

Original text of this message

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