Oracle Data Types
The following table contains the available data types for Oracle databases supported by CONNX.

CONNX Data Type | SQL Data Type | Length | VMS Equivalent Data Type | Description
Big Double Text | CHAR | 48 |  | Oracle Large Number (38)
Binary (Text) | CHAR | 1-30000 | Maxcim RFA Maxcim Byte Array | The binary field is not converted. It provides access to raw, unaltered data in an RMS file.
BLOB | LONG VARBINARY | 0-2147483000 |  | Binary Large Object
CLOB | LONG VARCHAR | 0-2147483000 |  | Character Large Object
Oracle Date | TIMESTAMP | 16 |  | Oracle Date
Oracle MLSLABEL | BINARY | 1-19 |  | Oracle MLSLABEL
Oracle Rowid | BINARY | 16 |  | Oracle Rowid
Oracle Timestamp | TIMESTAMP | -1 |  |
Text (Right Space Padded) | CHAR | 1-30000 | Text Maxcim Yes/No | Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding.
Text Space Padded (no nulls) | CHAR | -1 |  |
Varbinary | VARBINARY | -1 |  |