Purpose
ALL_PROCEDURES displays all functions and procedures accessible to the current user as well as their properties.
Related views
DBA_PROCEDURES
USER_PROCEDURES
Fields
Field |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the package. |
| PROCEDURE_NAME | VARCHAR2(128) | NO | The name of the procedure or function. |
| OBJECT_ID | NUMBER | NO | The object ID. |
| SUBPROGRAM_ID | NUMBER | NO | The sequence of appearance in the package. For an independent procedure or function, the value is 1. |
| OVERLOAD | NUMBER | NO | The nth overloading in the package source file. |
| OBJECT_TYPE | VARCHAR2(9) | NO | The type of the object. |
| AGGREGATE | VARCHAR2(3) | NO | Indicates whether the procedure is an aggregate function. At present, this field is not supported and is NO by default. |
| PIPELINED | VARCHAR2(3) | NO | Indicates whether the procedure is a pipelined table function. |
| IMPLTYPEOWNER | VARCHAR2(30) | NO | The name of the owner of the implementation type. At present, this field is not supported and is NULL by default. |
| IMPLTYPENAME | VARCHAR2(30) | NO | The name of the implementation type. At present, this field is not supported and is NULL by default. |
| PARALLEL | VARCHAR2(3) | NO | Indicates whether the procedure or function is parallel-enabled. |
| INTERFACE | VARCHAR2(3) | NO | Indicates whether the procedure or function is a table function implemented by using ODCI. At present, this field is not supported and is NULL by default. |
| DETERMINISTIC | VARCHAR2(3) | NO | Indicates whether the procedure or function is declared to be deterministic. |
| AUTHID | VARCHAR2(12) | NO | INVOKER/DEFINER |
| ORIGIN_CON_ID | NUMBER(38) | NO | At present, this field is not supported and is NULL by default. |