| OCI: LOBs and Array Interface? [message #94017] |
Wed, 03 September 2003 08:32 |
Ole Hansen
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
Hi,
I have a hard time inserting BLOBs with my array interface, ie. OCIBindArrayOfStruct().
How should I use the LobLocator when using the array interface?
If I want to insert say 100 rows with 2 colums of type BLOB each, should I do 2*100 OCIDescriptorAlloc(), 2*100 OCILobCreateTemporary(), and when should I call OCILobWrite() then? After calling OCIStmtExecute() or could that be done before? Or should I only use 2 locators for this scenario even though I have 100 rows when using the array interface?
I have tried different things but often get the ORA-22275 error: invalid LOB locator specified.
I have data available when I start building the statement, so I can do whatever is needed in any order. If I only knew how..
I guess I should store a unique locator for each BLOB column but nothing seems to work.
Any example will help.
Thanks in advance.
Br,
Ole Hansen
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
