Click to See Complete Forum and Search --> : Problems with Oracle BLOB


cactus25
September 17th, 1999, 01:14 PM
I have a small table(IMAGE_STORE) that has:
OPEENT VARCHAR2(22)
IMAGE BLOB.

Normally, I can do this to get to working with the table:


//Open the dynaset
ores = dset.Open(datab, "select * from image_store");
if(ores != OSUCCESS)
{
long errNum = dset.ErrorNumber();
const char *errTxt = dset.LookupErrorText(errNum);
cout << "Error opening session" << endl;
exit(-1);
}




However, because of the BLOB, I am getting errors opening it. I know this because this code will work:

//Open the dynaset
ores = dset.Open(datab, "select OPEENT from image_store");
if(ores != OSUCCESS)
{
long errNum = dset.ErrorNumber();
const char *errTxt = dset.LookupErrorText(errNum);
cout << "Error opening session" << endl;
exit(-1);
}




Any ideas?
thanks,
Cactus