DataType Mapping

Oracle Type	Catalyst DataType
CHAR(n)	StringType
VARCHAR(n)	StringType
NCHAR(n)	StringType
NVARCHAR(n)	StringType
NUMBER(p), p<=2	ByteType
NUMBER(p), p<=4	ShortType
NUMBER(p), p<=9	IntegerType
NUMBER(p), p<=18	LongType
NUMBER(p), p>18	DecimalType(p, 0)
NUMBER(p, s), s>p	Not supported
NUMBER(p, s), s<0	Not supported
NUMBER(p, s), p<38	DecimalType(p, s)
NUMBER(p, s), p>=38	DecimalType(38, 18)
FLOAT	broken, TODO
LONG	StringType
BINARY_FLOAT	FloatType
BINARY_DOUBLE	DoubleType
DATE	DateType
DATE	DateType
TIMESTAMP(s)	TimestampType
TIMESTAMP WITH TZ	TODO
TIMESTAMP WITh LOCAL TZ	TODO