Overview
DBA_ARGUMENTS lists the arguments of the procedures and functions that are available in the database. Its columns are the same as those in ALL_ARGUMENTS.
Related views
ALL_ARGUMENTS
USER_ARGUMENTS
Field description
| Field name | 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 sequential 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 data type length. |
| IN_OUT | VARCHAR2(5) | YES | The direction of the argument. A null value indicates a return value. Valid values: * IN * OUT * IN OUT |
| DATA_PRECISION | NUMBER(38) | YES | The maximum length of a numeric argument. |
| 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 for character sets. |
| 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. |