Re: Max Cursor error using Oracle

sfayed@xxxxxxxxxxxxxxx wrote:
Hello,

Does anyone have a good solution to close cursors when using Oracle 9
with VB.NET. I have tried disposing of the command object, the data
adapter and increasing the OPEN_CURSORS variable to a higher number
still nothing consistently works.

When too many cursors are opened, I receive the max cursor error.

Any suggestions would be greatly appreciated!

Thanks,
Scott

We are currently using .NET 1.1 and Oracle 9.

I only have more questions:
Are you using the Oracle .Net driver, or the one built into VS?
Are you using connection pooling?
Are you using statement caching?
Are you using wizard generated adapters?
What is OPEN_CURSORS set at?

I am running .Net 2.0 and Oracle 9.2.0.7, and have never encountered this error,
so I know it is possible for it to work right. I can't think of anything in
particular that I do, it just takes care of itself. Maybe if you post more info?


.

Relevant Pages

  • Re: Oracle scheme
    ... > rbscheer@my-deja.com (Robert Scheer) wrote in message ... > found that Oledb does not support Oracle cursors. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle and PHP with Cursors
    ... we are using Oracle and PHP for a Web application. ... We are using ref cursors to return data from oracle ... every row is request with one call to oracle. ...
    (comp.databases.oracle.misc)
  • Oracle Client, stored procedures and Cursor release.
    ... Does anybody know if it possible to force Oracle to release cursors that ... ie My app makes a call that populates a field in a datagrid row ... so it does take more than a few grid refreshes before you hit ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Oracle cursor help
    ... DELETE/WHERE clauses consume too many resources. ... I can also limit the row set up front with a pretty simple WHERE clause -- whatever is more efficient is what I'm aiming for (it wasn't clear to me if limiting up front with WHERE clauses defeated the efficiency of cursors ...) ... Can you work with the parallel options (Oracle Enterprise Edition)? ...
    (perl.dbi.users)
  • Max Cursor error using Oracle
    ... I have tried disposing of the command object, ... adapter and increasing the OPEN_CURSORS variable to a higher number ... When too many cursors are opened, I receive the max cursor error. ... We are currently using .NET 1.1 and Oracle 9. ...
    (microsoft.public.dotnet.languages.vb)