DSXchange

Hi,

I have a job, where i extract a long datatype column from oracle Database. I tried extracting with Varchar(4000) and more and tried using Varbinary, but nothing works.

I am getting the following error:

main_program: Unsupported SQL type LONG or LONG VARCHAR for column TEXT.

Is there a way to get this long datatype columns in an output dataset/file?

They're not supported but you may be able to CAST it to a varchar in your source sql. Or use the dbms_lob.substr function there. This may work better over OCI in a Server job than in PX.