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.
Wednesday, October 7, 2009
Oracle: Listing All Invalid PLSQL Packages
SELECT count(*)
FROM ALL_OBJECTS
WHERE owner = 'MYAPP'
and OBJECT_TYPE like 'PACKAGE\%'
and status = 'INVALID'; ";
No comments:
Post a Comment