Help, how to save graphic files into oracle database ?

Hi,

Currently i am facing a problem with saving images into oracle database. I will describe the scenario,
i am using VB-6.0 for my development. In one of the form, the user has to select the image file (bmp) through
common dialog open file box.

Then the image file is loaded in the picture box control now i need to save the image into oracle database.
I don't have any idea .. and also the approach whether to use recordset or just sql statements. The respective
column in oracle table is LONG RAW data type.

please help some one who did the similar kind of work earlier or if they had any ideas please respond asap.

Hi

You'll need to take a look at the Recordset AppendChunk method - the VB Help files have some examples that do just this.

Bascially, you read the picture/file/whatever in from disk in 'chunks' and append them to the field in the recordset. These are then written away to the Oracle Database on the 'Update' method of the recordset.

Regards

Chris Eastwood

CodeGuru - the website for developers
http://www.codeguru.com/vb