The following table lists Oracle Sales Cloud data types supported by the driver and how they are mapped to JDBC data types.

See getTypeInfo() for getTypeInfo() results of data types supported by the driver.

Table 1. Oracle Sales Cloud data types
Oracle Sales Cloud data type JDBC data type
BOOLEAN BOOLEAN
DECIMAL DECIMAL
INTEGER1 INTEGER or BIGINT or DECIMAL
LONG BIGINT
LONGSTRING LONGVARCHAR
STRING2 VARCHAR
1 When precision is less than or equal to 9, INTEGER is mapped as INTEGER. When precision is greater than 9, INTEGER is mapped as BIGINT. When no precision is specified, INTEGER is mapped as DECIMALwith a precision of 19 and a scale of 4.
2 When no precision for STRING fields is offered in the metadata, STRING is mapped as VARCHAR with a length of 4000 characters. When precision for STRING columns is available, the precision is maintained and STRING is mapped as VARCHAR.