Purpose
The DBA_PROCEDURES view displays all available functions and procedures in the database as well as their properties. Its columns are the same as those of the ALL_PROCEDURES view.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
ALL_PROCEDURES
USER_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 of the object in the package. For an independent procedure or function, the value is 1. |
| OVERLOAD | NUMBER | NO | The sequence number of overloading of the object in the package source file. |
| OBJECT_TYPE | VARCHAR2(9) | NO | The type of the object. |
| AGGREGATE | VARCHAR2(3) | NO | At present, this column is not supported and its value is NO by default. |
| PIPELINED | VARCHAR2(3) | NO | Indicates whether the procedure is a pipelined table function. |
| IMPLTYPEOWNER | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| IMPLTYPENAME | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| PARALLEL | VARCHAR2(3) | NO | Indicates whether the procedure or function is parallel-enabled. |
| INTERFACE | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| DETERMINISTIC | VARCHAR2(3) | NO | Indicates whether the procedure or function is declared to be deterministic. |
| AUTHID | VARCHAR2(12) | NO | Indicates whether authorization of the current user or the definer is required. Valid values: CURRENT_USER and DEFINER |
| ORIGIN_CON_ID | NUMBER(38) | NO | At present, this column is not supported and its value is NULL by default. |