Savepoints and cursors

[mmout]

I have a question concerning savepoints and cursors.

My program is using one Oracle session for retrieval and modifcations on the database.

Every time at modification (update) I set a savepoint and so a cursor is created for that session.

Then a couple of queries are executed and when successful the session is committed else rollbacked.

When I commit the session the cursor for toraclequery is cleaned up but the savepoints are not. Result is that I get 'maximum of open cursors exceeded'.

Is there a way to remove the savepoint cursors but keeping the session?

Best regards,

Marteijn

 

[Marco Kalter]

The TOracleSession will keep one cursor open for jobs like SavePoint, RollbackToSavepoint, SetTransaction, and so on. Surely one open cursor should not lead to 'maximum of open cursors exceeded'?

------------------
Marco Kalter
Allround Automations