| 27. 5. 12. Listing Stored Procedure Information |
|
|
Oracle provides several data dictionary views that provide information about procedures that are currently stored in your schema: |
- all_errors: A list of current errors on all objects accessible to the user
- all_source: Text source of all stored objects accessible to the user
- user_objects:A list of all the objects the current user has access to
- dba_errors:Current errors on all stored objects in the database
- dba_object_size:All PL/SQL objects in the database
- dba_source:Text source of all stored objects in the database
- user_errors:Current errors on all a user's stored objects
- user_source:Text source of all stored objects belonging to the user
- user_object_size:User's PL/SQL objects
|
|
SELECT object_name, object_type
from user_objects
WHERE status = 'INVALID';
|
|