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 Supported : java.time.ZonedDateTime, requires Java 8 and Oracle JDBC 21c Driver, but works also with older Oracle Databases.
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 - STRONG 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 - WEAK CURSOR Not supported : Impossible to determine type will cause a list of Java Objects - useless for resilient developing / 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 Due to unofficial Oracle Java SDO-Libraries removed from generator.
%ROWTYPE Removed since it isn't supported from Oracle 19c JDBC Driver. Also a bad development pattern.