Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Function Procedure Packages

 

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';