DSXchange

Try using Long VarChar as the data type in your metadata. What is the data type when you import the table definition from Oracle?

Thank you for your reply. The data type is VARCHAR2 if we use wire driver and NVARCHAR2 with nowire driver.

We have tried LONGNVARCHAR and it gave a metadata mismatch error plus an 'invalid precision value' error.

ray.wurlod wrote:Try using Long VarChar as the data type in your metadata. What is the data type when you import the table definition from Oracle?

The metadata mismatch and precision mismatch are warnings, and should not prevent the job from executing.

thanks again Ray but the data was not loaded into the table.