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
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!

  • Attachment: testoci.txt
    (Size: 5.64KB, Downloaded 377 times)
Previous Topic: PRO*C Coding Standards
Next Topic: Using SQLDA under 64 bits
Goto Forum:

Current Time: Sat Aug 19 23:12:55 CDT 2017

Total time taken to generate the page: 0.27983 seconds