Purpose
The ALL_PROCEDURES view lists all functions and procedures that are accessible to the current user, along with associated properties.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
DBA_PROCEDURESUSER_PROCEDURES
Columns
| Column | 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 column 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 column is not supported and is NULL by default. |
| IMPLTYPENAME | VARCHAR2(30) | NO | The name of the implementation type. At present, this column 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 OBCI. At present, this column 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 column is not supported and is NULL by default. |