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) NOT NULL	Object owner.
OBJECT_NAME	VARCHAR2 (30) NOT NULL	Object name.
PACKAGE_NAME	VARCHAR2 (30)	Package name.
OBJECT_ID	TT_BIGINT NOT NULL	Object number.
OVERLOAD	VARCHAR2(12) INLINE	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)	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 tuple, 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	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	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)	Data type of the argument.
DEFAULTED	VARCHAR2 (1) NOT NULL	Specifies whether or not the argument is defaulted.
DEFAULT_VALUE	VARCHAR2(4194304) NOT INLINE	Reserved for future use.
DEFAULT_LENGTH	TT_INTEGER	Reserved for future use.
IN_OUT	VARCHAR2 (9) 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)	Character set name for the argument.
TYPE_OWNER	VARCHAR2 (30)	Owner of the type of the argument.
TYPE_NAME	VARCHAR2 (30)	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)	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)	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)	For numeric arguments, the name of the PL/SQL type of the argument. NULL, otherwise.
CHAR_LENGTH	NUMBER	Character limit for string data types.
CHAR_USED	VARCHAR2 (1) NOT NULL	Indicates whether the byte limit (B) or char limit (C) is official for the string.