Re: Triggers de-compile themselves

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