How do you loop through the cursor? By binding it to a datareader? Did you
try to set the behaviour flag for the datareader? (so it will close the
source when done) ?
I don't think a cursor can be left open when the connection is closed, as
the cursor uses the connection to retrieve new data when you move the cursor.
The debate of what's best: straight sql or a proc is to hot to do it all
over again here I think. On Oracle, developers are often faced with a big
load of procedures they have to deal with, so cursors is all they got.
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.yqcomputer.com/
My .NET Blog: http://www.yqcomputer.com/
Microsoft C# MVP