DSXchange

In my extract job, the select query is getting data from LONG column along with other types [number, varchar2]. Whenever I run this job it fails with following error
- OCI has fetched truncated data
- Oracle Error - OCI_INVALID_HANDLE
and job gets aborted.

If i remove the only LONG column and run the job, it fetches the data correctly.
How to fetch the long column in SELECT

I dind't think that LONG was supported, but am not sure. How long is your definition?

Yes, Long is not supported but as an work-around use varchar with a bigger size.