SELECT *
FROM user_objects
WHERE object_type='PACKAGE' AND status = 'INVALID'

Connect time(ms): 78

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 31

OBJECT_NAME|SUBOBJECT_NAME|OBJECT_ID|DATA_OBJECT_ID|OBJECT_TYPE|CREATED|LAST_DDL_TIME|TIMESTAMP|STATUS|TEMPORARY|GENERATED|SECONDARY
EPMFTVALIDATORPK||11323||PACKAGE|2006-10-27 00:59:10.0|2006-10-28 03:43:48.0|2006-10-28:03:43:42|INVALID|N|N|N
EPMSUPPORTINGDATAPK||11298||PACKAGE|2006-10-27 00:59:03.0|2006-10-28 03:43:48.0|2006-10-28:03:43:48|INVALID|N|N|N
EPM_FAMILY_TABLE_UTILS||11341||PACKAGE|2006-10-27 00:59:15.0|2006-10-28 03:43:48.0|2006-10-28:03:43:47|INVALID|N|N|N

