The following table lists supported Oracle Sales Cloud data types and their equivalent ODBC data types.

Table 1. Oracle Sales Cloud data types
Oracle Sales Cloud data type ODBC data type
BOOLEAN SQL_BIT(-7)
DECIMAL SQL_DECIMAL(3)
INTEGER1 SQL_INTEGER(4) or SQL_BIGINT(-5) or SQL_DECIMAL(3)
LONG BIGINT (-5)
LONGSTRING SQL_WLONGVARCHAR(-10) or SQL_LONGVARCHAR(-1)
STRING2 SQL_VARCHAR(12)
1 When precision is less than or equal to 9, INTEGER is mapped as INTEGER for JDBC and SQL_INTEGER(4) for ODBC. When precision is greater than 9, INTEGER is mapped as BIGINT for JDBC and SQL_BIGINT(-5) for ODBC. When no precision is specified for JDBC, INTEGER is mapped as DECIMAL with a precision of 19 and a scale of 4. For ODBC, when no precision is specified, INTEGER is mapped as SQL_DECIMAL(3) with 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 for JDBC and SQL_VARCHAR(12) with a length of 4000 characters for ODBC. When precision for STRING columns is available, the precision is maintained and STRING is mapped as VARCHAR for JDBC and SQL_VARCHAR(12) for ODBC.