[unixODBC-dev] Too many cursors open
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
>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.
More information about the unixODBC-dev