I have a very simple interface from DB2 to Oracle.
One of the column has CLOB data type.
when I run interface it's failing
in mapping if
1. I put source column name : Error is-Invalid data type
2. If I put ' ' then error is " ORA00932 Inconsistent data type Expected CLOB.
also doesn't allowing NULL for CLOB data type.
Can somebody pleas advice on this.
I haven't worked with DB2 before, but you could try either "LKM SQL to Oracle (CLOB)" or "LKM SQL to Oracle Lob" from here: