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

Oracle Data Type Java Type
VARCHAR2 java.lang.String
NVARCHAR2
CHAR
NCHAR
CLOB
NCLOB
LONG

Numeric Data Types

Oracle Data Type Java Type
NUMBER Supported : The Java type depends on the Numeric Conversion Model.
FLOAT
BINARY_INTEGER
BINARY_FLOAT
BINARY_DOUBLE

Date And Timestamp Data Types

Oracle Data Type Java Type
DATE Supported : The Java type depends on the Date Conversion Model.
TIMESTAMP Supported : The Java type depends on the Timestamp Conversion Model.
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH Not supported
INTERVAL DAY TO SECOND Not supported

Binary Data Types

Oracle Data Type Java Type
LONG byte[]
RAW
LONG RAW
BLOB
BFILE Not supported

ROWID Data Types

Oracle Data Type Java Type
ROWID Not supported
UROWID Not supported

PL/SQL Data Types

Oracle Data Type Java Type
PL/SQL BOOLEAN Not supported
PL/SQL RECORD Supported : The PL/SQL record is represented by a transfer object.
PL/SQL TABLE Supported : The element must be of type number or varchar2.
TYPED REF CURSOR 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.
REF CURSOR/SYS_REFCURSOR Not supported : Impossible to determine type will cause a list of objects / use TYPED REF CURSOR instead.

Object Data Types

Oracle Data Type Java Type
OBJECT TYPE Supported : The object type is represented as a transfer object.
COLLECTION of TABLE or VARRAY(n) Supported : The collection is represented by a Java list of scalar types or transfer objects.

Special Data Types

Oracle Data Type Java Type
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).