Load >2,000 byte string into Oracle using DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
data type
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.
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: