Oracle Ocistmtexecute memory problems

[arianne2010]

We are experiencing a large consume of memory in WinXP with our OCI code when OCIStmtExecute() returns a controlled error.
The code is written in Visual C++ and we are using Oracle Server release 10.2.0.3 and Oracle Client release 9.2.0.1.0.

We don’t have detect any performance problems when we inserts massive data (thousand of records) without errors.

This is an example of how we use OCIStmtExecute():

if ( (status = OCIStmtExecute(svchp, stmthp1, errhp1, 1, 0, 0, 0, 0)) && status != 1)
{
OCITransRollback(svchp, errhp1, (ub4) 0);
if (stmthp1) OCIHandleFree((dvoid *) stmthp1, OCI_HTYPE_STMT);
if (errhp1) OCIHandleFree((dvoid *)errhp1, (ub4)OCI_HTYPE_ERROR);
return FALSE;
}

Did anybody met this problem?
Thanks in advance.

 

[SantaMufasa]

Arianne,

Welcome to both Tek-Tips and to our Oracle Forums. I hope your time here is rewarding.

I'm sorry that I have not had experience with your problem. I suggest that besides posting your inquiry here, that you also post your question in the forum205, where there are over 12,000 participants there that might be able to suggest an answer.

Good luck,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[arianne2010]

Thanks for your suggestion Mufasa.