I have a database connection where I execute many insert and update statements before I perform a commit since I want the ability to roll the entire transaction back if any one insert or update fails along the way.
On larger transactions I'm running into maximum open cursor errors (Oracle 10.2 database). I thought I had alleviated the problem by correctly closing the statements after execution. This helped but did not get rid of the problem. I obviously can't close my connection otherwise I can't roll back the transaction.
Is there something else I may not be doing correctly or do I simply have to commit the transaction sooner and deal with the repercussions of any errors received afterwards.
On larger transactions I'm running into maximum open cursor errors (Oracle 10.2 database). I thought I had alleviated the problem by correctly closing the statements after execution. This helped but did not get rid of the problem. I obviously can't close my connection otherwise I can't roll back the transaction.
Is there something else I may not be doing correctly or do I simply have to commit the transaction sooner and deal with the repercussions of any errors received afterwards.