Oracle Raw Field

nkj · Post by **nkj** » Thu Dec 08, 2005 5:16 pm

I need to read field type Raw from oracle database using ODBC stage to do look ups on that field and then load it back to oracle database. When i try to read data is read as varbinary and length of data is twice the length as viewed in database. When i try to load it back it is giving truncation error messages for eg
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated

Data is size of Raw 16 but when i read from datastage ODBC stage it looks like 3032303030303134303030303034363344443033303030323030303030303938.

Whats the right equivalent of raw 16 in datasatge- is varbinary 16 correct

Please let me know whats the right way to handle oracle raw field in datastage.

Thanks in advance

loveojha2 · Post by **loveojha2** » Thu Dec 08, 2005 10:19 pm

Try increasing the size of the field in the job which you are using for this raw field (as error is of the truncation). Did you try using LongVarbinary? and let us know what happened.

nkj · Post by **nkj** » Fri Dec 09, 2005 11:03 am

I tried that too. It didnot worked.