Information on Procedures

user_procedures view has information on procedures. Some of the columns in user_procedures:

Column	Type	Description
OBJECT_NAME	VARCHAR2(30)	The object name, which may be a procedure, function, or package name
PROCEDURE_NAME	VARCHAR2(30)	The procedure name
AGGREGATE	VARCHAR2(3)	Whether the procedure is an aggregate function(YES or NO)
IMPLTYPEOWNER	VARCHAR2(30)	owner
IMPLTYPENAME	VARCHAR2(30)	name
PARALLEL	VARCHAR2(3)	Whether the procedure is enabled for parallel queries (YES or NO)

all_procedures view has information on all the procedures you have access to.


SQL> SELECT object_name, aggregate, parallel
  2  FROM user_procedures
  3  WHERE object_name = 'UPDATE_SALARY';

OBJECT_NAME                    AGG PAR
------------------------------ --- ---
UPDATE_SALARY                  NO  NO

SQL>

Home »
Oracle »
PL/SQL »

Procedures:

Creating a Procedure
Pass parameters using named and mixed notation.
Information on Procedures
Dropping a Procedure
Viewing Errors in a Procedure