Purpose
The DBA_PROCEDURES view displays all available functions and procedures as well as their properties in the database. Its columns are the same as those of ALL_PROCEDURES.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_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 | |
| ORIGIN_CON_ID | NUMBER(38) | NO | At present, this column is not supported and is NULL by default. |