Longvarbinary datatype problem in a job

shaonli · Post by **shaonli** » Thu May 24, 2007 11:43 pm

Source of my job is SQL server table.It has a column whose datatype is Longvar binary (length-214748364).
The target table is oracle 9i.I am creating the table from job with same datatype.
The table is getting created with datatype LongRaw.But The job is getting aborted with error "Oracle datatype not presently supported".

Is datastage 7.5.2 not able to handle longvar binary?
Please suggest.

ray.wurlod · Post by **ray.wurlod** » Fri May 25, 2007 1:36 am

LongVarBinary is not a supported data type.

chulett · Post by **chulett** » Fri May 25, 2007 2:13 am

In particular, it's complaining about the Oracle LongRaw datatype not being supported.

shaonli · Post by **shaonli** » Fri May 25, 2007 2:38 am

Thanks for the info.

chulett · Post by **chulett** » Fri May 25, 2007 7:49 am

I can't help with the SQL Server question about LongVarBinary support. For the Oracle side, however, I would definitely avoid LONG or LONG RAW datatypes. They're really something you were stuck with in Oracle7 but since then have been deprecated and one should now use the 'new' LOB fields, introduced in 8i and enhanced since then.

Lots of information out there on the subject. Here's one such example that I Googled up. Hope it helps.