Long Datatype

dnat · Post by **dnat** » Thu Dec 17, 2009 5:13 am

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?

chulett · Post by **chulett** » Thu Dec 17, 2009 7:12 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 17, 2009 1:44 pm

Moderator: please move to parallel forum