SQL>
SQL> SELECT object_type, object_name, status, created, last_ddl_time
2 FROM user_objects
3 WHERE object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE',
4 'PACKAGE BODY', 'TRIGGER')
5 AND status = 'INVALID'
6 and rownum < 50;
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE DELETE_CUST INVALID 17-JUL-08
24-JUL-08
PROCEDURE WAIT INVALID 16-JUL-08
24-JUL-08
PACKAGE WORKPLACE_TYPE_TS INVALID 16-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PACKAGE BODY WORKPLACE_TYPE_TS INVALID 16-JUL-08
24-JUL-08
PACKAGE WORKER_TYPE_TS INVALID 16-JUL-08
24-JUL-08
PACKAGE GENDER_TS INVALID 16-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PACKAGE BODY GENDER_TS INVALID 16-JUL-08
24-JUL-08
PACKAGE WORKER_TS INVALID 16-JUL-08
24-JUL-08
PACKAGE BODY WORKER_TS INVALID 16-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PACKAGE BODY WORKER_TYPE_TS INVALID 16-JUL-08
24-JUL-08
PROCEDURE P_RUN_INSERT INVALID 17-JUL-08
24-JUL-08
PROCEDURE ROW_AT_A_TIME_TEST INVALID 17-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE BULK_TEST INVALID 17-JUL-08
24-JUL-08
PACKAGE CLASSPACKAGE INVALID 28-JUN-08
24-JUL-08
PACKAGE BODY CLASSPACKAGE INVALID 28-JUN-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE FCREATE INVALID 14-JUL-08
24-JUL-08
PROCEDURE CLOSECUR INVALID 14-JUL-08
24-JUL-08
PROCEDURE SAVESTRINGTOFILE INVALID 14-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE PUT_BOOLEAN INVALID 14-JUL-08
24-JUL-08
PROCEDURE CREINDX INVALID 14-JUL-08
24-JUL-08
PROCEDURE GET_LINE INVALID 14-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
FUNCTION RECEIVE_MESSAGE INVALID 14-JUL-08
24-JUL-08
FUNCTION TRACEIT INVALID 14-JUL-08
24-JUL-08
PROCEDURE SEND_MESSAGE INVALID 14-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PACKAGE ONECUR INVALID 14-JUL-08
24-JUL-08
PROCEDURE SHOWEMPS INVALID 14-JUL-08
24-JUL-08
PROCEDURE PROCA INVALID 14-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE PROCB INVALID 14-JUL-08
24-JUL-08
PACKAGE BODY MYDATE INVALID 14-JUL-08
24-JUL-08
PROCEDURE SHOW_FILE INVALID 14-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
FUNCTION FOPEN INVALID 14-JUL-08
24-JUL-08
FUNCTION EMP_COUNT INVALID 14-JUL-08
24-JUL-08
PROCEDURE ORG_PROC INVALID 15-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
FUNCTION F_CURSOR_EXP INVALID 15-JUL-08
24-JUL-08
PROCEDURE P_PRINT_REPORT INVALID 15-JUL-08
24-JUL-08
FUNCTION F_CURSOR_EXP_COMPLEX INVALID 15-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
FUNCTION GETALLHIERARCHIES INVALID 15-JUL-08
24-JUL-08
PACKAGE BODY ORGMASTER INVALID 15-JUL-08
24-JUL-08
FUNCTION F_GET_FORMATTED_ORG_NAME INVALID 15-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PACKAGE BODY RFPKG INVALID 15-JUL-08
24-JUL-08
PACKAGE BODY RFPKG2 INVALID 15-JUL-08
24-JUL-08
PACKAGE NOCOPYPKG INVALID 15-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PACKAGE BODY NOCOPYPKG INVALID 15-JUL-08
24-JUL-08
PROCEDURE UPDATE_DYN_GLOBAL_BULK2 INVALID 16-JUL-08
24-JUL-08
PACKAGE BODY ORGMASTER2 INVALID 15-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE UPDATE_DYN_GLOBAL_BULK INVALID 16-JUL-08
24-JUL-08
PACKAGE SRPKG2 INVALID 15-JUL-08
24-JUL-08
PACKAGE BODY SRPKG2 INVALID 15-JUL-08
24-JUL-08
OBJECT_TYPE OBJECT_NAME STATUS CREATED
------------------- ------------------------- ------- --------------------
LAST_DDL_
---------
PROCEDURE LOG_ERROR INVALID 15-JUL-08
25-JUL-08
49 rows selected.
SQL>