OCI: How to insert BLOBs from OCI ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Ole Hansen

    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 OCIDescriptorAl loc() and uses this to allocate
    space for my data (app. 1Mb). Afterwards I store data in memory
    allocated by OCIDescripterAl loc.

    I do the following for each column
    OCIBindByPos( ... )
    OCIBindArrayOfS truct( ... )

    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

Working...