| Help! column incompatibility issue during data migration sqlserver-oracle [message #561818] |
Wed, 25 July 2012 06:59 |
 |
lola_bas
Messages: 3
Registered: July 2012
|
Junior Member |
|
|
Hi, I really need some suggestions fom my problem cause I have no idea how to solve it and I've been stumbling on it for some time.
I'm trying to create a code template mapping for migrating data from a sql table to an oracle table with OWB 11.2.0.1 (I'm using a JDBC driver). The sql table contains a NVARCHAR(MAX) type column which is mapped to a corresponding NCLOB type column in the Oracle table.
When I try to execute the mapping i get the following error: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got NCLOB
It's clearly an incompatibility issue between those two but how can I get past this error? I doesn't work with transformation operators, I've tried.
Maybe someone more experienced with OWB can help me with this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
