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.