SYS.ALL_ARGUMENTS

The ALL_ARGUMENTS view lists the arguments of the procedures and functions that are accessible to the current user.

Related views

SYS.DBA_ARGUMENTS lists the arguments of the procedures and functions that are available in the database. It has the same columns as ALL_ARGUMENTS.
SYS.USER_ARGUMENTS describes the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
`OWNER`	`VARCHAR2(30) INLINE`	Object owner
`OBJECT_NAME`	`VARCHAR2(30) INLINE`	Object name
`PACKAGE_NAME`	`VARCHAR2(30) INLINE`	Package name
`OBJECT_ID`	`TT_BIGINT NOT NULL`	Object number
`OVERLOAD`	`VARCHAR2(12) INLINE`	Overloading Indicates the `n`th overloading ordered by its appearance in the source; otherwise, it is `NULL`.
`SUBPROGRAM_ID`	`TT_INTEGER`	Unique subprogram identifier
`ARGUMENT_NAME`	`VARCHAR2(30) INLINE`	Argument name If the argument is a scalar type, then the argument name is the name of the argument. A null argument name denotes a function return. If the function return or argument is a composite type, this view will have one row for each attribute of the composite type. Attributes are recursively expanded if they are composite. The meanings of `ARGUMENT_NAME`, `POSITION`, `SEQUENCE`, and `DATA_LEVEL` are interdependent. Together, as a row, they represent a node of a flattened tree. `ARGUMENT_NAME` can refer to: Return type, if `ARGUMENT_NAME` is `NULL` and `DATA_LEVEL = 0` The argument that appears in the argument list if `ARGUMENT_NAME` is `NOT NULL` and `DATA_LEVEL = 0` Attribute name of the composite type if `ARGUMENT_NAME` is `NOT NULL` and `DATA_LEVEL > 0` A collection element type if `ARGUMENT_NAME` is `NULL` and `DATA_LEVEL > 0`
`POSITION`	`TT_INTEGER NOT NULL`	Item position If `DATA_LEVEL` is 0, then this column contains the position of this item in the argument list, or 0 for a function return value. If `DATA_LEVEL` is greater than 0, then this column contains the position of this item with respect to its siblings at the same `DATA_LEVEL`. For a referenced record field, this is the index of the field within the record. For a referenced collection element, this is 1 because collection elements do not have siblings.
`SEQUENCE`	`TT_INTEGER NOT NULL`	Argument sequence Defines the sequential order of the argument and its attributes. Argument sequence starts at 1. Return type and its recursively expanded (preorder tree walk) attributes come first, and each argument with its recursively expanded (preorder tree walk) attributes follow.
`DATA_LEVEL`	`TT_INTEGER NOT NULL`	Nesting depth of the argument for composite types
`DATA_TYPE`	`VARCHAR2(30) INLINE`	Data type of the argument
`DEFAULTED`	`VARCHAR2(1) INLINE NOT NULL`	Default status Specifies whether the argument is defaulted.
`DEFAULT_VALUE`	`VARCHAR2(4194304) NOT INLINE`	For future use
`DEFAULT_LENGTH`	`TT_INTEGER`	For future use
`IN_OUT`	`VARCHAR2(9) INLINE NOT NULL`	Direction of the argument: (`IN`, `OUT`, `IN OUT`)
`DATA_LENGTH`	`TT_INTEGER`	Length of the argument
`DATA_PRECISION`	`TT_INTEGER`	Length in decimal digits (`NUMBER`) or binary digits (`FLOAT`)
`DATA_SCALE`	`TT_INTEGER`	Digits to the right of the decimal point in a number
`RADIX`	`TT_INTEGER`	Argument radix for a number
`CHARACTER_SET_NAME`	`VARCHAR2(16) INLINE`	Character set name for the argument
`TYPE_OWNER`	`VARCHAR2(30) INLINE`	Owner of the type of the argument
`TYPE_NAME`	`VARCHAR2(30) INLINE`	Name of the type of the argument If the type is a package local type (declared in a package specification), then the column displays the name of the package.
`TYPE_SUBNAME`	`VARCHAR2(30) INLINE`	Declared type This is relevant for package local types. Displays the name of the type declared in the package identified in the `TYPE_NAME` column.
`TYPE_LINK`	`VARCHAR2(128) INLINE`	Database link This is relevant for package local types when the package identified in the `TYPE_NAME` column is a remote package. This column displays the database link used to refer to the remote package. TimesTen ignores this value because remote packages are not supported.
`PLS_TYPE`	`VARCHAR2(30) INLINE`	For numeric arguments, the name of the PL/SQL type of the argument Otherwise, `NULL`
`CHAR_LENGTH`	`NUMBER`	Character limit for string data types
`CHAR_USED`	`VARCHAR2(1) INLINE NOT NULL`	`B` for byte limit or `C` for character limit for the string