Oracle Data Types
The following tables show the correspondences of Oracle to IBM® Lotus Enterprise Integrator® (LEI) 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 LEI 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 |
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) |