Feature
DBA_ARGUMENTS displays the arguments of the available functions and procedures in the database. Its fields are the same as those of ALL_ARGUMENTS.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_ARGUMENTS
USER_ARGUMENTS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| 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 composite types, the value of this field 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 | At present, this field indicates the tenant ID. |