Re: How to find triggers compiled with errors

Hello,

try this statement.

select status, object_name from user_objects where OBJECT_TYPE = 'TRIGGER' and status = 'INVALID';

CU, Holger Lehmann

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:40:38 CET