Max Cursor error using Oracle

[sfayed@carolina.rr.com]

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.

[Steve Gerrard]

Re: Max Cursor error using Oracle

sfayed@carolina .rr.com 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?