Feature
USER_PROCEDURES displays all functions and procedures owned by the current user, as well as their associated properties. Its fields are the same as those of the ALL_PROCEDURES view, except that it does not have the OWNER field.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_PROCEDURES
ALL_PROCEDURES
Fields
| Field | 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 field 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 field is not supported and is NULL by default. |
| IMPLTYPENAME | VARCHAR2(30) | NO | The name of the implementation type. At present, this field 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 ODCI. At present, this field 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 | Valid values: INVOKER and DEFINER. |
| ORIGIN_CON_ID | NUMBER(38) | NO | At present, this field is not supported and is NULL by default. |