|
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
|
|
Default value for the argument
|
|
DEFAULT_LENGTH
|
NUMBER
|
|
Length of the default value for the argument
|
|
IN_OUT
|
VARCHAR2(9)
|
|
Direction of the argument:
|
|
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.
|
