Rants and ravings of a semi-autistic developer who has a hard time remembering idiotic nonsense details. Why remember it, when you know where to find it.
SELECT count(*) FROM ALL_OBJECTS WHERE owner = 'MYAPP' and OBJECT_TYPE like 'PACKAGE\%' and status = 'INVALID'; ";