Supported Oracle Database Data Types

The following table lists the Oracle Database data types and the corresponding Flogo data types.

Oracle Database DataType	Flogo Data Type
CHAR VARCHAR VARCHAR2 NCHAR NVARCHAR INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND	String
NUMBER BINARY_FLOAT BINARY_DOUBLE FLOAT	Number
DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE	Date-time

Oracle Database DataType

Flogo Data Type

CHAR

VARCHAR

VARCHAR2

NCHAR

NVARCHAR

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

String

NUMBER

BINARY_FLOAT

BINARY_DOUBLE

FLOAT

Number

DATE

TIMESTAMP

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH LOCAL TIME ZONE

Date-time