Load >2,000 byte string into Oracle using DataStage

ray.wurlod · Post by **ray.wurlod** » Tue Mar 01, 2011 3:25 pm

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

iq_etl · Post by **iq_etl** » Wed Mar 02, 2011 3:14 pm

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?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 02, 2011 3:28 pm

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

iq_etl · Post by **iq_etl** » Wed Mar 02, 2011 3:37 pm

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