too many open cursors

[Lars Vegas]

Hi,
I've a big problem with Oracle/Borland classes. Im using the borland class QueryDataSet. That class has a method closeStatement(), which is supposed to close the open cursor on the database. but it doesn't seem to work. The open cursors remain open. so, after a while I get the big bang. Has anyone experience with problems like this? Or, if not, how can I close the open cursors although I don't know the names of the not-active cursors?
Any help appreciated.
Lars

[Asif Equbal]

The problems sems to be with the init.ora file setting .
Change ur init.ora parameter names max_open_cursor = 200 ( default it is 50) .
i think this will do the Job

------------------
Asif Equbal
Cognizant Technology Solutions , India.

[Lars Vegas]

Thanks for trying to help. But I don't want to raise the allowed maximum of open cursors, because it will lower performance. I want to close the open cursors, that are not needed anymore!!!

[Lars Vegas]

Thanks for trying to help, but I don't want to raise the allowed number of open cursors, I want to close the not needed open cursors. In my application even 200 open cursors won't be enough. And I cannot raise to 5000. I need performance and I just don't want to keep these cursors!!!
Lars

[Beksy Kurian]

close the resultset and the statement.
Regards
Beksy

[Lars Vegas]

I cannot close the statement, because the function closeStatement() from the Borland class QueryDataSet is NOT working!!! The function does not close the statement. And replacing the whole Borland stuff is not possible anymore in short time!!!
Any help still appreciated.
Lars