Hi,

We have a problem with the number of open cursors. We have noticed that when you close or free a TOracleDataSet the number of opened cursors doesn't decrease. We have tried using the CloseAll function and it doesn't seem to work. The only way we know to see the number of open cursors is with:

Select count(*) From v$Open_Cursor

This causes our applications to raise the "Maximum open cursors exceeded error". We know we could increase the OPEN_CURSOR variable.

Does anybody knows a methods to correct this? Is this a a bug of DOA?

TIA.

Net8 keeps cursors open so that they can be reused when you open a new cursor. You will indeed not see the number of open cursors decrease after freeing a dataset, but you will not see it increase after creating and opening a new dataset either. It's just a Net8 cursor buffering mechanism, and does not eat into the OPEN_CURSORS limit.

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

Thanks Marco.

We have noticed that, sometimes, when you create a Query up to three cursors are created: one containing the SQL text of the query and two with something like this:

table_64_200_3138_0_0_0
table_ac_2000_3138_0_0_0

The first one disappears when you free it and create another one but these two not.

Any idea?

TIA

These 2 cursors are created for CLOB, BLOB, or BFILE access. They are used internally by Oracle when you read or write LOB data. You won