Home » Developer & Programmer » Precompilers, OCI & OCCI » How do I batch update BLOB column in OCI? (Oracle 9.2)
How do I batch update BLOB column in OCI? [message #352644] Wed, 08 October 2008 14:46
svrid
Messages: 1
Registered: October 2008
Location: GA, US
Junior Member
We are currently using ODBC(C application). Due to performance issues we are thinking about using OCI drivers for certain functions. OCI was chosen due to its batch Update capabilities. We're not quite sure, how the code should be structured to achieve best performance using OCI driver.

I have attached my test code with this.

The problem with the code is that even after i > MAX_BATCH_COUNT, OCIStmtExecute keeps returning OCI_NEED_DATA. I am not sure what data it is looking for.

Is this the right way to implement such a function? Is there a better way to code the batch update functionality for improved performance. The same code has to work under Oracle 9i, 10g and higher.

Please help!

Thanks
Sathya
  • Attachment: testoci.txt
    (Size: 5.64KB, Downloaded 2002 times)
Previous Topic: FAQ's on PRO*C
Next Topic: Using SQLDA under 64 bits
Goto Forum:
  


Current Time: Thu Mar 28 16:48:28 CDT 2024