ALL_ARGUMENTS

Columns
   ___________________________
 
   IN_OUT
      Argument direction (IN, OUT, or IN/OUT)
   TYPE_OWNER
      Owner name for the argument type in case of object types
   TYPE_SUBNAME
      Subordinate object name for the argument type in case of object types
   OVERLOAD
      Overload unique identifier
   PLS_TYPE
      PL/SQL type name for numeric arguments
   TYPE_LINK
      Database link name for the argument type in case of object types
   DATA_LEVEL
      Nesting depth of argument for composite types
   DEFAULT_LENGTH
      Length of default value for the argument
   DEFAULT_VALUE
      Default value for the argument
   CHARACTER_SET_NAME
      Character set name for the argument
   RADIX
      Argument radix for a number
   DATA_SCALE
      Digits to right of decimal point in a number
   DATA_PRECISION
      Length: decimal digits (NUMBER) or binary digits (FLOAT)
   DATA_LENGTH
      Length of the column in bytes
   TYPE_NAME
      Object name for the argument type in case of object types
   ARGUMENT_NAME
      Argument name
   OBJECT_ID
      Object number of the object
   PACKAGE_NAME
      Package name
   OBJECT_NAME
      Procedure or function name
   OWNER
      Username of the owner of the object
   DATA_TYPE
      Datatype of the argument
   POSITION
      Position in argument list, or null for function return value
   SEQUENCE
      Argument sequence, including all nesting levels

Related Commands:

DBMS_METADATA - Retrieve complete database object definitions

 USER_ARGUMENTS