Hi All,

Can anyone let me know how to get BLOB data from the data base using an adapter service and what should be the driver type used for that connection to get BLOB data type.

I want to transform the BLOB data that we recieve to xml.

Thanks in Advance.

Mouli.

Hi Mouli,

I think u should select the output field as byte array in Adapter templete and after selecting them and using convert them to string.

Thanks for your solution…almost it worked but in the output string i can see lot of junk characters in between the actual alphabets.

Do we need to provide any Encoding format while converting to string ?

Also i would like to convert that data into xml whose format(schema) is different for each record.
Please suggest.

Thanks in Advance.

Regards,
Mouli.