Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clear a ref_cursor in oracle
Message
From
03/05/2004 17:11:18
 
 
To
03/05/2004 16:55:49
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00900481
Message ID:
00900521
Views:
27
i have another question to go along with this because I get the same error using the code below.

ado2.strSQL = "Select * From X Where y = 1"
ado2.RetrieveReader()

If ado2.objDR.Read() Then
end if

ado2.objdr.close
ado2.closeconnection

Regular VB6 apps do queries all day long against this oracle database and they never get the too many open cursors error. Why would the above code create an oracle cursor and not close it? Is this a .NET error? It just seems to me like I am writing the code I need to, but the cursor is not destroyed until my application ends. Could Session Pooling have anything to do with this and if so, how can I control it? Thanks again for the help.
Randy Belcher
AFG Industries, Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform