Supported Data Types
The supported datatypes depends on the possibilities of the Oracle JDBC driver. Not all parameter types for PL/SQL programming are supported by the Oracle JDBC driver. The supported datatypes can be used in any mixed combinations.Character Data Types
VARCHAR2 | java.lang.String |
NVARCHAR2 | |
CHAR | |
NCHAR | |
CLOB | |
NCLOB | |
LONG |
Numeric Data Types
NUMBER | Supported : The Java type depends on the Numeric Conversion Model. |
FLOAT | |
BINARY_INTEGER | |
BINARY_FLOAT | |
BINARY_DOUBLE |
Date And Timestamp Data Types
DATE | Supported : The Java type depends on the Date Conversion Model. |
TIMESTAMP | Supported : The Java type depends on the Timestamp Conversion Model. |
Not supported | |
Not supported |
Binary Data Types
LONG | byte[] |
RAW | |
BLOB | |
BFILE | Not supported |
ROWID Data Types
ROWID | Not supported |
UROWID | Not supported |
PL/SQL Data Types
Not supported | |
Supported : The PL/SQL record is represented by a transfer object. | |
Supported : The element must be of type number or varchar2. | |
Supported : Cursor supported as OUT-parameter. The data type is converted to a Java list of transfer objects. Each transfer object can be of scalar type or PL/SQL record type. | |
Not supported : Impossible to determine type will cause a list of objects / use TYPED REF CURSOR instead. |
Object Data Types
Supported : The object type is represented as a transfer object. | |
Supported : The collection is represented by a Java list of scalar types or transfer objects. |
Special Data Types
XMLTYPE | Supported : org.w3c.dom.Document |
SDO_GEOMETRY | Supported : oracle.spatial.geometry.JGeometry |
%ROWTYPE | Supported : Rowtype is represented by a transfer object (identically to PL/SQL Record). |