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 topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
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 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. |