Re: Triggers de-compile themselves

From: <fitzjarrell_at_cox.net>
Date: Thu, 7 Aug 2008 09:18:37 -0700 (PDT)
Message-ID: <f015ccdd-28e2-4a35-b8ee-f7cb38a1856f@l64g2000hse.googlegroups.com>


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.
>
> 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