Re: How to find triggers compiled with errors

Hi,

Try to select STATUS from USER_OBJECTS....

brgds, Michael Ringbo
Fraser Boswell wrote:

> I have a piece of PL/SQL which automatically generates a trigger for
> auditing purposes on a any chosen table. So far fine, and if it is
> disabled I also know that I can find this though All_Triggers view.
> But how can I find out if it compiled with errors, and is invalid?
> In SQL Navigator invalid triggers are flagged red, so it must be
> possible?
>
> Thanks in advance
>
> Fraser
Received on Tue Nov 16 1999 - 12:23:22 CET