help: retrieving blob objects from an oracle8 database using odbc?

From: Samir Guermach <guermach_at_dfki.uni-kl.de>
Date: Mon, 22 Jun 1998 15:02:13 +0200
Message-ID: <358E55D5.CCB30909_at_dfki.uni-kl.de>

I am trying to retrieve blob objects from an oracle database using odbc.

I tried to use the code as decribed in the online help, but it is not working.
the code I wrote is:
SQLExecDirect(statement, "select blobObject from table where id=1",SQL_NTS)
SQLFetch(statement);
rc=SQLGetData(statement,1,SQL_C_BINARY,buff,length,&dataLength); The first two operations success but the third (SQLGetData) fails. I became an rc=SQL_ERROR with sqlstate =S1000

                                                       nativecode=0
                                                      errorMsg=General

Error.
I remarked also that nothing was written into my buffer and dataLength is after the call equal to length.
Can any one help me solve this problem Received on Mon Jun 22 1998 - 15:02:13 CEST