Re: Triggers de-compile themselves
Date: Thu, 7 Aug 2008 09:18:37 -0700 (PDT)
On Aug 7, 10:49 am, Adam Cameron <adam_j..._at_hotmail.com> 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.
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