How to find triggers compiled with errors
From: Fraser Boswell <fraser.boswell_at_ed.ac.uk>
Date: Tue, 16 Nov 1999 11:07:15 +0000
Message-ID: <38313AE3.FFB74A42_at_ed.ac.uk>
[Quoted] [Quoted] 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?
Date: Tue, 16 Nov 1999 11:07:15 +0000
Message-ID: <38313AE3.FFB74A42_at_ed.ac.uk>
[Quoted] [Quoted] 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:07:15 CET