Data Extract fails with Long column in SELECT clause

Sushilsb · Post by **Sushilsb** » Tue Aug 28, 2007 2:03 pm

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

ArndW · Post by **ArndW** » Tue Aug 28, 2007 3:28 pm

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

us1aslam1us · Post by **us1aslam1us** » Tue Aug 28, 2007 4:03 pm

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