Query user_objects table for all procedure
SQL>
SQL>
SQL> select object_name, status
2 from user_objects
3 where object_type = 'PROCEDURE' and rownum < 100;
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
PSTUBT VALID
PSTUB VALID
SUBPTXT2 VALID
SUBPTXT VALID
ODCIINDEXINFOFLAGSDUMP VALID
ODCIINDEXINFODUMP VALID
ODCIPREDINFODUMP VALID
ODCIQUERYINFODUMP VALID
ODCICOLINFODUMP VALID
ODCISTATSOPTIONSDUMP VALID
ODCIENVDUMP VALID
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
ODCIINDEXALTEROPTIONDUMP VALID
ODCIINDEXCALLPROPERTYDUMP VALID
ODCITABFUNCINFODUMP VALID
LOGMNR_KRVRDLUID3 VALID
LOGMNR_KRVRDREPDICT3 VALID
DBMS_LOGMNR_FFVTOLOGMNRT VALID
LOGMNR_KRVRDA_TEST_APPLY VALID
DBMS_LOGMNR_OCTOLOGMNRT VALID
LOGMNR_GTLO3 VALID
AW_DROP_PROC VALID
LOAD_UNDO_STAT VALID
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
RESET_UNDO_STAT VALID
DBMS_FEATURE_PARTITION_USER VALID
DBMS_FEATURE_PARTITION_SYSTEM VALID
DBMS_FEATURE_PLSQL_NATIVE VALID
DBMS_FEATURE_RAC VALID
DBMS_FEATURE_TEST_PROC_1 VALID
DBMS_FEATURE_TEST_PROC_2 VALID
DBMS_FEATURE_TEST_PROC_3 VALID
DBMS_FEATURE_TEST_PROC_4 VALID
DBMS_FEATURE_TEST_PROC_5 VALID
DBMS_FEATURE_REGISTER_ALLFEAT VALID
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
DBMS_FEATURE_REGISTER_ALLHWM VALID
VALIDATE_CONTEXT VALID
SET_TABLESPACE VALID
EMP_LOOKUP INVALID
MY_PROC VALID
SHOW_EMP INVALID
SWAP VALID
LOG_MESSAGE INVALID
INSERT_INTO_T INVALID
FOO INVALID
INSERT_NUMBERS INVALID
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
OUT_PARMS VALID
THREE_PARMS VALID
DEFAULT_VALUES VALID
THREE_PARAMS VALID
SHOW_OBJECTS VALID
SET_JETSON_CONTEXT VALID
50 rows selected.
SQL>
Related examples in the same category