Showing posts with label plsql. Show all posts
Showing posts with label plsql. Show all posts

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'; ";