OCI: How to insert BLOBs from OCI ?

Ole Hansen

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

Jul 19 '05 #1