DSXchange

Posted: **Wed Aug 11, 2004 11:51 am**

Hi,
I am trying to load data from oracle table to another oracle table and I am getting an error " OCI has fetched truncated data" Why is that so??
can somebody help..
Thanks...

Posted: **Wed Aug 11, 2004 11:58 am**

You have a field in your source table that is not "properly" defined in the job. By that I mean the defined size is too small. Typically, this is because you have a LONG or NUMBER field you are extracting. Any chance of this?

Note that I literally mean NUMBER as opposed to something like NUMBER(38). The metadata that imports via OCI for these columns is not correct and can cause the problem you are seeing. If you have one, try changing its size to 40 and see if the error goes away.