Home » Developer & Programmer » Precompilers, OCI & OCCI » OCI: LOBs and Array Interface?
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
Previous Topic: Comparing oci and pro*c performance
Next Topic: Regarding Pro*C precompiler
Goto Forum:
  


Current Time: Thu Mar 28 17:30:03 CDT 2024