Purpose
The USER_PROCEDURES view displays all functions and procedures owned by the current user, as well as their associated properties. Its columns are the same as those of the ALL_PROCEDURES view, except that it does not have the OWNER column.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
DBA_PROCEDURES
ALL_PROCEDURES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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. |