Supported Data Types

Supported data types depend on the capabilities of the Oracle JDBC driver. Some PL/SQL parameter types cannot be handled through JDBC and are therefore not supported by the Connector Builder. All supported types can be combined freely in a single procedure or function signature.

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 is selected via 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 is selected via the Date Conversion Model.
TIMESTAMP	Supported: the Java type is selected via the Timestamp Conversion Model.
TIMESTAMP WITH TIME ZONE	Supported: java.time.ZonedDateTime. Requires Java 8+ and the Oracle JDBC 21c driver. Works with older Oracle Database versions as well.
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: mapped to a transfer object.
PL/SQL TABLE	Supported: element type must be NUMBER or VARCHAR2.
TYPED REF CURSOR (strong)	Supported as an OUT parameter. The cursor is converted to a Java List of transfer objects. Each row can be mapped to scalar fields or to a record-based transfer object.
REF CURSOR / SYS_REFCURSOR (weak)	Not supported: the element type cannot be determined reliably and would degrade to List<Object>. Use a typed REF CURSOR instead.

Object Data Types

Oracle Data Type	Java Type
OBJECT TYPE	Supported: mapped to a transfer object.
COLLECTION (TABLE or VARRAY(n))	Supported: mapped to a Java List of scalar values or transfer objects.

Special Data Types

Oracle Data Type	Java Type
XMLTYPE	Supported: org.w3c.dom.Document
SDO_GEOMETRY	Not supported: generator support was removed because the required Oracle SDO Java libraries are not officially distributed.
%ROWTYPE	Not supported: removed because it is not supported by the Oracle 19c JDBC driver and is generally discouraged as a design pattern.