467,907 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

OCI: How to insert BLOBs from OCI ?


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
  • viewed: 2503

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Howard Lowndes | last post: by
2 posts views Thread by Jerry LeVan | last post: by
2 posts views Thread by Chris | last post: by
reply views Thread by Ole Hansen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.