All my datasets are created dynamically, and I'm pretty sure they are all freed appropriately. I will add some logging code to the constructor / destructor (I encapsulate TOracleDataset in my own class) to see if any are not being freed.
Incidentally is there a query I can run on oracle to tell...
I'm constantly running into this oracle exception after my app has been running for a couple of hours.
I'm using DOA4.0.6/Oracle10g server/9.2i client/Delphi7 pro
I think the default max per session is 300.
I'm using the following to see how many cursors are open. Is it correct?
select *
from...