Toad World® Forums

ER: Only show INVALID objects that have Errors


#1

When viewing INVALID objects in the SB LHS Packages tab, it would be useful to have an option to only show objects that are INVALID but that also have Errors (on the error tab) associated with them. This would make it a lot easier to identify objects that had “real” rather than re-compilation errors.

Richard


#2

Hi Richard,

You can use the custom filter checkbox in the SB filter dialog to add this to
the query:

and not exists (select ‘x’

from dba_errors e

where e.name = o . object_name

and e. owner = o . owner

and e.type = o . object_type )

(or maybe you want ‘exists’ rather than ‘not exists). It makes
the query pretty slow though.

-John