Thats a nasty OCI API error as it retrieves a field that requires to be defined differently in DS. The annoying part is, its trial and error. ie, you have to try changing the sql type and the length. Good luck.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
amitendra_amit wrote:Any idea why this error is coming.
No not really, not with so little information SunShine.
However, we can make some guesses. What kind of fields are in your source table(s)? Anything fun like a CLOB? If not a CLOB are there any NUMBER fields defined? Not NUMBER(xx) but just NUMBER... those are the two primary suspects when you see this error.
-craig
"You can never have too many knives" -- Logan Nine Fingers