OCI: How to insert BLOBs from OCI ?

Hi,

I have a working application inserting rows to a table using the array interface. Now I want to insert BLOBs as well but OCIStmtExecute crashes when executed with BLOBs.

For BLOB types I use OCIDescriptorAlloc() and uses this to allocate space for my data (app. 1Mb). Afterwards I store data in memory allocated by OCIDescripterAlloc.

I do the following for each column
OCIBindByPos( ... )
OCIBindArrayOfStruct( ... )

but what should skip parameter be when the column is of type BLOB? And how/where is the actual size of blob data set?

What have I missed?

Thanks in advance.
Ole Hansen Received on Thu Jul 10 2003 - 10:47:23 CEST