Oracle Data Types


When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data type mappings applicable when working with an Oracle database.

Oracle Database Type

Spotfire Data Type

Supported

BFILE

Binary

Yes

BINARY_DOUBLE / REAL

Real

Yes

BINARY_FLOAT / FLOAT

SingleReal

Yes

BLOB

Binary

Yes

CHAR

String

Yes

CLOB

String

Yes

DATE

Date

Yes

INTERVAL DAY TO SECOND

TimeSpan

Yes

INTERVAL YEAR TO MONTH

LongInteger

No

LONG

String

Yes

LONG RAW

Binary

Yes

NCHAR

String

Yes

NCLOB

String

Yes

NUMBER                        (NUMBER(x, s))

 

 

   Boolean (NUMBER(1))

Boolean

Yes

Note: NULL values will be interpreted as False.

   Integer (NUMBER(p) 2 <= p <= 9)

Integer

Yes

   Long (NUMBER(p) 10 <= p <= 18)

LongInteger

Yes

   Double (NUMBER(x, s) 16 > x > s > 0)

Real

Yes

                                          (NUMBER(x, s))

Real

Yes

NVARCHAR / NVARCHAR2

String

Yes

PLS_INTEGER

 

No

RAW

Binary

Yes

RAW(16)

String

Yes

REF

 

No

REF CURSOR

 

No

ROWID

String

Yes

TIMESTAMP

DateTime

Yes

TIMESTAMP WITH LOCAL TIME ZONE

DateTime

No

TIMESTAMP WITH TIME ZONE

DateTime

No

UROWID

String

Yes

VARCHAR / VARCHAR2

String

Yes

XMLType

String

No

See also:

Details on Oracle Connection

Supported Functions