I'm working on a Digital Unix machine.
I have Oracle8i Installed and also using OCI 8.1.6 library.
I'm using OCIStmtPrepare, OCIStmtExecute and OCIStmtFetch in my application to handle select queries..
But then after every transaction, I'm releasing the statement handle and recreating it using OCIHandleAlloc and OCIHandleFree, but After every 50 transaction i hit with this error...
ORA-1000 Maximum number of open cursors exceeded
I went and changed the init ora parameters to a higher value for open_cursors but then I dont want the cursors to be open even after doing OCIHandleFree, Is there something else that needs to be done to release the cursor I'm not able to figure out wutz causing this problem,I'm stuck at this problem and not able to proceed further..