Last updated on JUNE 28, 2016
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 31-Dec-2012***
***Checked for ODI 11g compliance on 31-Dec-2012***
The execution of an Oracle Data Integrator (ODI) Integration Interface based on a LKM using an Oracle DBLINK fails
- Until ODI 11g, on the "Create view on source" step, and the following message is signaled:
Create or replace view Exception getObjectNameDefaultPSchema("L", "", "W") : C$_0...
- From ODI 22.214.171.124.0 onward, on the "Create synonym on target" step, and the following message is signaled:
java.lang.StringIndexOutOfBoundsException: String index out of range: 103
and the code ODI tries to execute shows an incorrect substitution of the table name:
create synonym MY_WORK_SCHEMA.C$_0MY_TABLE
for Exception getObjectName("R", "%COL_PRF0MY_TABLE", "W")
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms