When importing entities from the databases, OutSystems Platform maps Oracle data types into OutSystems data types.

The map between the data types is specified in the following table:

Oracle data Types

OutSystems data types

BLOB

Binary Data

CHAR

Text

CLOB

Text

DATE

Date

NCLOB

Text

NUMBER

 

if Number(1) -> Boolean,

if Number(10,0) -> Integer,

if Number(20,0) -> Long Integer,

otherwise -> Decimal.

NVARCHAR2

Text

 

TIMESTAMP

Date Time

VARCHAR2

Text

All other data types

Unsupported

See Also

Available Data Types | DB2 Data Types to OutSystems Data Types | MySQL Data Types to OutSystems Data Types | SQL Server Data Types to OutSystems Data Types