Item type properties
The following table lists the Oracle data types and the values of the item type properties to which they correspond in a generated type tree. The DBMS dictates the length of each type except for the DATE type. The DATE type length is 19.
| Oracle Data Type | Interpret as | Item Subclass, Presentation |
|---|---|---|
| VARCHAR2 | Character | Text |
| NVARCHAR2 | Character | Text |
| INTEGER | Character | Number, Integer |
| NUMBER Precision = 0 Scale = 0 |
Character | Number, Decimal |
| NUMBER Precision > 0 Scale = 0 |
Character | Number, Integer |
| NUMBER Precision > 0 Scale > 0 |
Character | Number, Decimal |
| FLOAT | Character | Number, Decimal |
| LONG | Character | Text |
| DATE | Character | Date & Time |
| RAW | Binary | Text |
| LONG RAW | Binary | Text |
| CHAR | Character | Text |
| NCHAR | Character | Text |
| BLOB | Binary | Text |
| CLOB | Character | Text |
| BFILE | Binary | Text |
| NCLOB | Character | Text |
| TIMESTAMP(f) | Character | |
| TIMESTAMP(f) WITH TIME ZONE | Character | Text |
| TIMESTAMP(f) WITH LOCAL TIME ZONE | Character | |
| INTERVAL DAY(d) TO SECOND(f) | Character | Text |
| INTERVAL YEAR(y) TO MONTH | Character | Text |
| XMLType | Character | Text |
| URIType | Character | Text |
*
The BLOB and NCLOB data types are not supported as parameters for stored procedures. The Oracle Adapter supports object types. These are alternatively referred to as abstract data types (ADT). The object type is a composite type that includes data types such as number, date, varchar, and so on. Object types can include nested object types.
When generating Oracle type trees that contain ADTs, you must manually edit the tree to make the ADT group required. This will prevent atomic null violations.