Oracle Open Cursor Problem?

[Adam Right]

Hi,

I am developing a program with visual studio 2005 beta using C#. I have a
problem about opened cursors on my Oracle 9i database. I cannot dispose
opened cursors although there is a close statement after fetch statement in
the database. It exceeds the maximum number of the opened cursors. How can i
close the opened cursors that are not being used by the program? Thanks...

 

[Dan Bass]

This problem isn't related to the fact that you're using .Net 2, it's to do
with the differences in the way SQL Server and Oracle handle their cursors.

I've had this problem too... Check this out:

http://www.c-sharpcorner.com/Code/2004/Aug/HandlingOracleCursor.asp