[unixODBC-dev] Too many cursors open

Nick Gorham nick.gorham at easysoft.com
Tue Nov 8 09:37:09 GMT 2005

anand.vasudevan at wipro.com wrote:

>We are using easysoft's ODBC oracle driver. We get this error after our
>application runs a few hundred queries: -
>'ORA-01000: maximum open cursors exceeded'.
>What could cause this error in the ODBC context?
>Should this be handled in the application code or at database
>administration level?
>This kind of error never ocurred with Ingres database.
AFAIK There is a server configuration parameter that sets this.

Also I would check your code to make sure it is closing connections. But 
I seem to remember the server will cache them as well.

Nick Gorham
Easysoft Limited

More information about the unixODBC-dev mailing list