Displaying Images that were BLOBs

Hi

I have problems viewing images that have been stored as blobs. I am able to convert them to files using the getchunk method but whenever I try to open them I get a message of either 'invalid file format' or 'unable
to determine type' depending on the application I use to open them. I believe that the code I have to convert the BLOB to a file is ok, since I am able to convert images to BLOBs and store them in the database, and then later retrieve them and they open fine. If I have to do some filtering or something, could someone please enlighten me?

I am using SQL server and ADO, the images seem to be ok since I am able to open them by binding an RDC to an OLE object.

Regards

D

Hi,

What is the SQL command for storing a file in a BLOB? I know how to initialize the field to an empty blob but I don't know how to store a file in the field.

There is also a lot of information on technet.oracle.com about BLOBs, but you really have to dig to find what you are looking for.

Thanks,

Preeti