Static Data Dictionary Views, 3 of 452

ALL_ARGUMENTS

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

Related view:

USER_ARGUMENTS lists all arguments of 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

Name of the owner of the object

OBJECT_NAME

VARCHAR2(30)

Name of the procedure or function

PACKAGE_NAME

VARCHAR2(30)

Package name

OBJECT_ID

NUMBER

NOT NULL

Name of the package containing the procedure or function

OVERLOAD

VARCHAR2(40)

Overload unique identifier

ARGUMENT_NAME

VARCHAR2(30)

Name of the argument

POSITION

NUMBER

NOT NULL

Position in argument list, or NULL for function return value

SEQUENCE

NUMBER

NOT NULL

Argument sequence, including all nesting levels

DATA_LEVEL

NUMBER

NOT NULL

Nesting depth of argument for composite types

DATA_TYPE

VARCHAR2(14)

Datatype of the argument

DEFAULT_VALUE

LONG

Default value for the argument

DEFAULT_LENGTH

NUMBER

Length of default value for the argument

IN_OUT

VARCHAR2(9)

Argument direction (IN, OUT, or 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 right of 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)

Username of the 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), 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 columns 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.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Name of the owner of the object
`OBJECT_NAME`	`VARCHAR2(30)`		Name of the procedure or function
`PACKAGE_NAME`	`VARCHAR2(30)`		Package name
`OBJECT_ID`	`NUMBER`	`NOT NULL`	Name of the package containing the procedure or function
`OVERLOAD`	`VARCHAR2(40)`		Overload unique identifier
`ARGUMENT_NAME`	`VARCHAR2(30)`		Name of the argument
`POSITION`	`NUMBER`	`NOT NULL`	Position in argument list, or NULL for function return value
`SEQUENCE`	`NUMBER`	`NOT NULL`	Argument sequence, including all nesting levels
`DATA_LEVEL`	`NUMBER`	`NOT NULL`	Nesting depth of argument for composite types
`DATA_TYPE`	`VARCHAR2(14)`		Datatype of the argument
`DEFAULT_VALUE`	`LONG`		Default value for the argument
`DEFAULT_LENGTH`	`NUMBER`		Length of default value for the argument
`IN_OUT`	`VARCHAR2(9)`		Argument direction (IN, OUT, or 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 right of 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)`		Username of the 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), 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 columns 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.