Re: Triggers de-compile themselves

From: <>
Date: Thu, 7 Aug 2008 09:18:37 -0700 (PDT)
Message-ID: <>

On Aug 7, 10:49 am, Adam Cameron <> wrote:
> 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.
> Cheers.
> --
> Adam

You'll need to look in USER_OBJECTS at LAST_DDL_TIME. It reflects the time of the last compile for an object such as a procedure, package, function or trigger.

David Fitzjarrell Received on Thu Aug 07 2008 - 11:18:37 CDT

Original text of this message