oracleDataset.Close vs oracleDataset.CloseAll

[jedaworks]

Could you please explain when I should use dataset.close, and when I should use dataset.closeAll?

My understanding is if the query changes, use closeAll, if the query is parameterized and is going to be reopened, use close. Is this correct?

I have a bunch of existing code that never calls closeAll (only calls dataset.close). Is this going to cause resource problems on the server?

 

[Marco Kalter]

You normally only need to use Close. The CloseAll procedure additionally closes all cursors on the server that are associated with the dataset. If your application has a lot of datasets, and if you don't have control over the OPEN_CURSORS initialization parameter of the database instance, this can be useful to limit the open cursors.

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