Home » Developer & Programmer » Warehouse Builder » Help! column incompatibility issue during data migration sqlserver-oracle (11.2.0.1)
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.
Previous Topic: Autosys-OWB -Issue
Next Topic: Table Functions
Goto Forum:
  


Current Time: Wed Oct 22 09:47:18 CDT 2014

Total time taken to generate the page: 0.04994 seconds