Feature
USER_ARGUMENTS displays the arguments of the functions and procedures owned by the current user. Its fields are the same as those of the ALL_ARGUMENTS 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_ARGUMENTS
ALL_ARGUMENTS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the procedure or function. |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package. |
| OBJECT_ID | NUMBER | NO | The object ID. |
| OVERLOAD | NUMBER | YES | The nth overloading in the package source file. |
| SUBPROGRAM_ID | NUMBER | YES | The sequence of appearance in the package. For an independent procedure or function, the value is 1. |
| ARGUMENT_NAME | VARCHAR2(128) | YES | The name of the argument. A null value indicates a function return. |
| POSITION | NUMBER(38) | NO | The position in the argument list. |
| SEQUENCE | NUMBER(38) | NO | The sequence order of the attribute for composite types. |
| DATA_LEVEL | NUMBER(38) | NO | The nesting depth of the argument for composite types. |
| DATA_TYPE | VARCHAR2(128) | YES | The data type of the argument. For nested composite types, this value indicates the data type of the current layer. |
| DEFAULTED | CHAR(2) | YES | Indicates whether the argument has a default value. |
| DATA_LENGTH | NUMBER(38) | YES | The length of the data type. |
| IN_OUT | VARCHAR2(5) | YES | The direction of the argument. A null value indicates a return value. Valid values: |
| DATA_PRECISION | NUMBER(38) | YES | The maximum length of a numeric value. |
| DATA_SCALE | NUMBER(38) | YES | The number of digits on the right of the decimal point in a number. |
| CHARACTER_SET_NAME | VARCHAR2(7) | YES | The name of the character set for the argument. |
| COLLATION | VARCHAR2(18) | YES | The collation of the character set. |
| TYPE_OWNER | NUMBER(38) | YES | The owner of the composite type. |
| TYPE_NAME | VARCHAR2(128) | YES | The name of the composite type. |
| TYPE_SUBNAME | VARCHAR2(128) | YES | The name of the package if the type is a package local type. |
| ORIGIN_CON_ID | NUMBER(38) | YES | This field indicates the tenant ID at present. |