< Prev - Documentation - Next >

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_FLOAT
BINARY_DOUBLE

Date And Timestamp Data Types

Oracle Data Type Java Type
DATE java.sql.Date
TIMESTAMP java.sql.Timestamp
TIMESTAMP WITH TIME ZONE java.sql.Timestamp
TIMESTAMP WITH LOCAL TIME ZONE java.sql.Timestamp
INTERVAL YEAR TO MONTH Not supported
INTERVAL DAY TO SECOND Not supported

Binary Data Types

Oracle Data Type Java Type
LONG byte[]
RAW byte[]
LONG RAW byte[]
BLOB byte[]
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 element types are number and varchar2.
TYPED REF CURSOR Cursor supported as OUT-parameter. The data type is converted to a Java list of transfer objects. The transfer object corresponds to the REF CURSOR row type.

Object Data Types

Oracle Data Type Java Type
OBJECT TYPE Supported. The object type is represented by a transfer object.
COLLECTION VARRAY, TABLE Supported. The collection is represented by a Java list of transfer objects.

Special Data Types

Oracle Data Type Java Type
XMLTYPE org.w3c.dom.Document
SDO_GEOMETRY oracle.spatial.geometry.JGeometry
%ROWTYPE Not supported.

< Prev - Documentation - Next >