Re: Triggers de-compile themselves

From: Adam Cameron <>
Date: Thu, 7 Aug 2008 16:49:13 +0100
Message-ID: <1y26leeutsfvo.bwbz3ttz5qpe$>

Oh... another thing.

Is there any way to detect the compilation state of a trigger (eg: whether it's been compiled or awaiting to be compiled).

I didn't see anything in the USER_TRIGGERS view which flags that. I'm not sure where else one might look.

(I haven't actually googled about this yet, so fair cop if the answer is "RTFM": I am going to do that now, but whilst I was here I thought I'd ask.


Received on Thu Aug 07 2008 - 10:49:13 CDT

Original text of this message