Data Integration Connector Release Notes > Connector and connectivity issues > Oracle Connector
  

Oracle Connector

Known issues

The following table describes known issues:
Issue
Description
CCON-107278
When you create a mapping enabled with SQL ELT optimization that uses multiple objects as the source type, the mapping might fail with the following error:
FnName: Execute Direct -- [28][ODBC Oracle Wire Protocol driver][Oracle]ORA-00904: "<schema_name>.<table_name>.<column_name>": invalid identifier]
Workaround: You can configure a join relationship in a Joiner transformation with multiple source instances in the mapping.
(May 2025)

Third-party known issues

The following table describes third-party known issues:
Issue
Description
CCON-98664
When you run a mapping to write data to a column with NVARCHAR2 data type, and the source data length exceeds the precision set for the target object, the rows are rejected with the following warning message:
ERROR: Writer execution failed. Database error: [0] [ FnName: Execute - [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-12899: value too large for column <schema name>.<table name>.<column name> (actual: 100, maximum: 50) ]
Data Direct ticket number: 01491535
(July 2024)