My Oracle Support Banner

ODI Integration Interfaces and the Use of Oracle Spatial Datatypes in Source and Target Datastores (Doc ID 424107.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Data Integrator - Version 4.1.01.05 and later
Information in this document applies to any platform.

Symptoms

When attempting to update an Oracle Spatial (such as MDSYS.SDO_GEOMETRY) datatype column in a table using the Oracle Data Integrator (ODI) "Oracle Incremental Update" Integration Knowledge Module, the process interrupts at the loading step of the I$ table with the following message:

ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 ODI 10.1.3.4.2 and later
 Earlier ODI versions and former Sunopsis
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.