ALL_ARGUMENTS

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

Related View

USER_ARGUMENTS lists the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(30)`		Name of the procedure or function
`PACKAGE_NAME`	`VARCHAR2(30)`		Name of the procedure or function
`OBJECT_ID`	`NUMBER`	`NOT NULL`	Object number of the object
`OVERLOAD`	`VARCHAR2(40)`		Overload unique identifier
`ARGUMENT_NAME`	`VARCHAR2(30)`		Name of the argument
`POSITION`	`NUMBER`	`NOT NULL`	Position in the argument list, or null for a function return value
`SEQUENCE`	`NUMBER`	`NOT NULL`	Argument sequence, including all nesting levels
`DATA_LEVEL`	`NUMBER`	`NOT NULL`	Nesting depth of the argument for composite types
`DATA_TYPE`	`VARCHAR2(30)`		Datatype of the argument
`DEFAULT_VALUE`	`LONG`		Reserved for future use
`DEFAULT_LENGTH`	`NUMBER`		Reserved for future use
`IN_OUT`	`VARCHAR2(9)`		Direction of the argument: `IN` `OUT` `IN/OUT`
`DATA_LENGTH`	`NUMBER`		Length of the column (in bytes)
`DATA_PRECISION`	`NUMBER`		Length in decimal digits (`NUMBER`) or binary digits (`FLOAT`)
`DATA_SCALE`	`NUMBER`		Digits to the right of the decimal point in a number
`RADIX`	`NUMBER`		Argument radix for a number
`CHARACTER_SET_NAME`	`VARCHAR2(44)`		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 (that is, it is declared in a package specification), then this column displays the name of the package.
`TYPE_SUBNAME`	`VARCHAR2(30)`		Relevant only 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 only 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.
`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 datatypes
`CHAR_USED`	`VARCHAR2(1)`		Indicates whether the byte limit (`B`) or char limit (`C`) is official for the string

See Also:

"USER_ARGUMENTS"