USER_ARGUMENTS

The USER_ARGUMENTS view provides information about the procedure and function arguments owned by the current user.

Column name	Data type	Description
`OBJECT_NAME`	`VARCHAR2(128)`	The name of the procedure or function.
`PACKAGE_NAME`	`VARCHAR2(128)`	The name of the package.
`OBJECT_ID`	`NUMBER`	The number of the object. Always `NOT NULL`.
`OVERLOAD`	`VARCHAR2(40)`	The n-th overloading ordered by its appearance in the source. Otherwise, it is `NULL`.
`SUBPROGRAM_ID`	`NUMBER`	A unique subprogram identifier.
`ARGUMENT_NAME`	`VARCHAR2(128)`	The name of the argument. The `NULL` argument name is used to denote a function return.
`POSITION`	`NUMBER`	The position of the item in the argument list. 0 is used for a function return value.
`SEQUENCE`	`VARCHAR2(128)`	The sequential order of the argument. The argument sequence starts from 1. A return type comes first, and each argument follows. Always `NOT NULL`.
`DATA_LEVEL`	`VARCHAR2(128)`	The nesting depth of the argument for composite types. Always `NOT NULL`. Note: Starting with Oracle Database 18c, the value of this column is always 0, because this view displays only one row for each argument. This view no longer displays multiple rows for composite type arguments.
`DATA_TYPE`	`VARCHAR2(30)`	The data type of the argument.
`DEFAULTED`	`VARCHAR2(1)`	Speсifies whether the argument is defined with a default value (`Y`) or not (`N`).
`DEFAULT_VALUE`	`LONG`	Reserved for future use.
`DEFAULT_LENGTH`	`NUMBER`	Reserved for future use.
`IN_OUT`	`VARCHAR2(128)`	The direction of the argument. The possible values are: `IN` `OUT` `IN/OUT`
`DATA_LENGTH`	`NUMBER`	The length of the column, in bytes.
`DATA_PRECISION`	`NUMBER`	The length of the column, expressed in decimal digits for the `NUMBER` data type or binary digits for the `FLOAT` data type.
`DATA_SCALE`	`NUMBER`	The number of digits to the right of the decimal point for the `NUMBER` data type.
`RADIX`	`NUMBER`	The radix used for the `NUMBER` data type of the argument.
`CHARACTER_SET_NAME`	`VARCHAR2(44)`	The character set associated with the argument.
`TYPE_OWNER`	`VARCHAR2(128)`	The owner of the argument’s data type.
`TYPE_NAME`	`VARCHAR2(128)`	The name of the argument’s data type. If the data type is a package local type (according to a package specification), this column displays the name of the package.
`TYPE_SUBNAME`	`VARCHAR2(128)`	The type name declared in the package that is identified in the `TYPE_NAME` column. Note: This applies only to package local types.
`TYPE_LINK`	`VARCHAR2(128)`	The database link used to refer to the remote package. Note: This applies only when the `TYPE_NAME` column identifies a remote package, not a local one.
`TYPE_OBJECT_TYPE`	`VARCHAR2(7)`	An object type indicated in the `TYPE_OWNER`, `TYPE_NAME`, and `TYPE_SUBNAME` columns. The possible values are: `TABLE` `VIEW` `PACKAGE` `TYPE`
`PLS_TYPE`	`VARCHAR2(128)`	For numeric arguments, the name of the PL/SQL type of the argument. Otherwise, it is `NULL`.
`CHAR_LENGTH`	`NUMBER`	A character limit for string data types.
`CHAR_USED`	`VARCHAR2(1)`	Specifies the measurement unit used to interpret the length of a character-type argument. The possible values are: `B` - The length is measured in bytes. `C` - The length is measured in characters.
`ORIGIN_CON_ID`	`VARCHAR2(256)`	The ID of the container where the data originates. The possible values are: `0` – Used for rows in non-CDBs. `n` – used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in the root).