p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   Maximum number of cursors exceeded. (http://p2p.wrox.com/showthread.php?t=67778)

zaheerabbas.sk April 30th, 2008 02:05 AM

Maximum number of cursors exceeded.
 
Hi,

I have written a windows service,in which Im using cursors to fetch data from the tables into a dataset.The service is giving an exception "Max number of open cursors exceeded", i have disposed, the connection object,command object, but the problem still exists. I have another idea of using GC.collect(),but it is degrading my service's performance. Any other solution would be appreciated.


Intellectuals solve problems but Genious avoid problems.

debasisdas July 4th, 2008 04:41 AM

you need to reset the parameter for the database.

Regards
Debasis


All times are GMT -4. The time now is 11:57 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.