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...
truncated data
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers