DBA_ARGUMENTS

DBA_ARGUMENTS lists the arguments of the procedures and functions that are available in the database. Its columns are the same as those in ALL_ARGUMENTS.

Related Views

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

· 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 package
OBJECT_ID	NUMBER	NOT NULL	Object number of the object
OVERLOAD	VARCHAR2(40)		Indicates the nth overloading ordered by its appearance in the source; otherwise, it is NULL.
SUBPROGRAM_ID	NUMBER		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 is used to denote 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 any of the following: · 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	NUMBER	NOT NULL	If DATA_LEVEL is zero, then this column holds the position of this item in the argument list, or zero for a function return value.If DATA_LEVEL is greater than zero, then this column holds the position of this item with respect to its siblings at the same DATA_LEVEL. So, 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	NUMBER	NOT NULL	Defines the sequential order of the argument and its attributes. Argument sequence starts from 1. Return type and its recursively expanded (preorder tree walk) attributes will come first, and each argument with its recursively expanded (preorder tree walk) attributes will follow.
DATA_LEVEL	NUMBER	NOT NULL	Nesting depth of the argument for composite types
DATA_TYPE	VARCHAR2(30)		Datatype of the argument
DEFAULTED	VARCHAR2(1)		Specifies whether or not the argument is defaulted
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

Note:

1. Query example of DBA_ARGUMENTS:

select owner, object_name, package_name, argument_name, position,

sequence, data_type, in_out, pls_type, char_length

from DBA_ARGUMENTS where owner = 'MDSYS' and object_name = 'DECODE';

OWNER	OBJECT_ NAME	PACKAGE_ NAME	ARGUMENT_ NAME	POSITION	SEQUENCE	DATA_TYPE	IN_ OUT	PLS_TYPE	CHAR_ LENGTH
MDSYS	DECODE	MD1		0	1	RAW	OUT	RAW	0
MDSYS	DECODE	MD1	HHCODE	1	2	RAW	IN	RAW	0
MDSYS	DECODE	MD1	DIMENSION_NUM	2	3	BINARY_INTEGER	IN	BINARY_INTEGER	0
MDSYS	DECODE	SDO		0	1	RAW	OUT	RAW	0
MDSYS	DECODE	SDO	HHCODE	1	2	RAW	IN	RAW	0
MDSYS	DECODE	SDO	DIMENSION_NUM	2	3	BINARY_INTEGER	IN	BINARY_INTEGER	0

Oracle data dictionary views

Oracle dynamic performance views