Oracle OCI Adapter Limitations

Supported Types

This adapter supports types as follows.

Type nameSupportRemarks
CHARLimited 
NCHARLimited 
VARCHAR2Limited 
NVARCHAR2Limited 
LONGLimited 
NUMBERLimited 
FLOATLimited 
DATELimited 
TIMESTAMPLimited 
TIMESTAMPTZ
TIMESTAMP WITH TIME ZONE
LimitedTreated as String data.
RAWLimited 
LONG RAWLimited 
BLOBLimited 
CLOBLimited 
NCLOBLimited 

Common to all processing

Specification Limits

Specific to Oracle Client 11g Release 1

Notes

Read Table

Specification Limits

Execute Select SQL

Specification Limits

Write table

Specification Limits

Execute Update SQL

Specification Limits

Execute Stored Procedure

Specification Limits

Oracle Client 11.2 specific

Write by Loader

Write by loader is not supported.

Main exceptions

Exception name Cause Actions
java.lang.UnsatisfiedLinkError OCI client's connection settings may be wrong. Please make sure the Jdbc OCI driver used is the same as the Oracle client.