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