Purpose
The ALL_ARGUMENTS view displays the arguments of the functions and procedures accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_ARGUMENTS
USER_ARGUMENTS
Columns
| Column | 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 column 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 column indicates the tenant ID. |