The illustration adatyp.gif shows the syntax for the type_dcl section of the parameter list described in the previous graphic.  Type_dcl can take on one of the following seven values: Option 1 is the keyword CHARACTER followed by an optional length value in parentheses.  The length value must be greater than 1 and less than 32,500.  Option 2 is the keyword DOUBLE_PRECISION.  Option 3 is the keyword INTEGER.  Option 4 is the keyword REAL.  Option 5 is the keyword SMALLINT.  Option 6 is the keyword VARCHAR2, followed by a required length value in parentheses.  The length value must be greater than 1 and less than 32,500.  Option 7 is the keyword SQL_CURSOR.