[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:

>Hi,
>
>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.
>
>Regards,
>Anand
>
>  
>
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