skip to main content
Welcome to the Progress DataDirect for JDBC for Oracle Sales Cloud Driver : Data types
  

Try DataDirect Drivers Now

Data types

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.

* getTypeInfo()