maximum open cursors exceeded (and I'm becoming one)

[DTaylor]

I'm running a Delphi5 program that I've written with DOA 343. All it does is write new records into a table. after a given number of records I get the ora-1000 error.

I'm re-using an OracleQuery (oq) for each update, but I oq.clear before using it, and I oq.close afterwards, which I would have thought would release the cursors. Obviously I'm missing something basic.

 

[DTaylor]

[sigh] never mind. I found a rogue select in there that was getting orphaned on each iteration.

 

[skalal]

You can change number of variable OPEN_CURSORS on Oracle Server.