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
Oracle Data Integrator - Version 4.1.01.05 and later Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!