Listing Stored Procedure Information : Procedure « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Procedure

Oracle provides several data dictionary views that provide information about procedures that are currently stored in your schema:

1. all_errors: A list of current errors on all objects accessible to the user
2. all_source: Text source of all stored objects accessible to the user
3. user_objects:A list of all the objects the current user has access to
4. dba_errors:Current errors on all stored objects in the database
5. dba_object_size:All PL/SQL objects in the database
6. dba_source:Text source of all stored objects in the database
7. user_errors:Current errors on all a user's stored objects
8. user_source:Text source of all stored objects belonging to the user
9. user_object_size:User's PL/SQL objects

SELECT object_name, object_type
from user_objects
WHERE status = 'INVALID';