Oracle Data Types

The following tables show the correspondences of Oracle to HCL Enterprise Integrator (HEI) or Domino® Enterprise Connection Services (DECS) data types for various types of activities.

(p) -- Indicates that if Allow Precision Loss is not enabled, then an error will be generated on the type match. Allowing precision loss is the default.
(o) -- Indicates that overflow checking will be performed when data is being transferred. If an overflow occurs and Truncate Data When Necessary is enabled, then the data is truncated; if not an error is generated.

You can specify only one LONG for each column/statement.

If you want to use BLOBs or RAWs they must originate in Notes®, then be inserted into the Oracle table, and then be read back into Notes®, otherwise they will not be in a format that Notes® can recognize. This is also true for HEI or DECS when a Notes® database is one of the connected databases. Oracle supports multibyte varying-width character sets.

Execute

The Execute data types are listed as follows.


Oracle		Connector API
NUMBER	prec-scale<=9, scale<=0	Int
	prec-scale<=15	Float
	Other	Numeric
FLOAT		Float
DATE		Datetime
CHAR		Text (fixed length, bound <= 2000)
VARCHAR2		Text (variable length, bound <= 4000)
LONG		Text (variable length, unbounded)
CLOB		Text (variable length, unbounded)
RAW		Binary (BLOB format) (variable length, bound <= 2000)
LONG RAW		Binary (BLOB format) -- variable length, unbounded
BLOB		Binary (BLOB format) -- variable length, unbounded

Note: There is a limitation on how Connectors interpret a Notes® NUMBER field. When you use the "Create Target Metadata" option from a Notes® source, heavy precision loss may occur with Notes® NUMBER fields.

Fetch

The Fetch data types are listed as follows.


Oracle	Connector API
FLOAT (p, o), NUMBER (p, o)	Int
FLOAT (p), NUMBER (p)	Float
FLOAT (p, o), NUMBER (p, o)	Currency
FLOAT (p, o), NUMBER (p, o)	Numeric
DATE	Datetime
CHAR, VARCHAR2, LONG, RAW, LONG RAW, CLOB, BLOB	Text (o)
CHAR, VARCHAR2, LONG, RAW, LONG RAW, CLOB, BLOB	Binary (o)	BLOB/composite

Insert/Update

The Insert/Update data types are listed as follows.


Connector API	Oracle
Int		NUMBER, FLOAT
Float		NUMBER (p), FLOAT (p)
Currency		NUMBER (p), FLOAT (p)
Numeric		NUMBER (p), FLOAT (p)
Datetime		DATE (p)
Text		CHAR (o), VARCHAR2 (o), LONG, RAW (o), LONG RAW, ROWID (o), CLOB, BLOB
Binary	any	CHAR (o), VARCHAR2 (o), LONG, RAW (o), LONG RAW, ROWID (o), CLOB, BLOB
	number list	NUMBER (p), FLOAT (p)
	datetime list	DATE (p)

Create

The Create data types are listed as follows.


Connector API	Oracle
Int		NUMBER (prec,0)
Float		FLOAT (prec) or NUMBER (prec, scale)
Currency		NUMBER (19, 4)
Numeric		NUMBER (prec, scale)
Datetime		DATE
Text		CHAR (fixed, len<=2000), VARCHAR2 (2000<len<=4000), or CLOB (len>=4000)
Binary	BLOB	RAW (fixed, len<=2000) or BLOB (len>2000)
	composite	CHAR (fixed, len<=2000), VARCHAR2 (2000<len<=4000), or CLOB (len>4000)
	number list	FLOAT (prec)
	datetime list	DATE
	text list	CHAR (fixed, len<=2000), VARCHAR2 (2000<len<=4000), or CLOB (len>4000)