These views provide information about PL/SQL functions, procedures, packages, and triggers:
Lists all valid arguments for stored procedures and functions.
Shows all errors from compiling objects.
Lists the external libraries that can be called from PL/SQL packages, procedures, and functions.
Shows the size of the compiled code for each PL/SQL package, procedure, function, and trigger.
Shows PL/SQL source for packages, procedures, and functions.
Lists columns that are referenced in triggers.
Shows PL/SQL code for database triggers.
Lists dependencies using only object numbers.