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.
|