Open cursors

From: Steve Morrell <Steve.Morrell_at_techprt.co.uk>
Date: 15 Jan 2004 08:38:56 -0800
Message-ID: <3d21a3ae.0401150838.a5638@posting.google.com>

Not sure if this is more a .Net question or an Oracle question but hey...

I have an OracleConnection object in C# that I'm passing around a lot of other objects in sequence. This way one connection is used for all objects and its basically saying "perform your job on this connection". However, despite the fact that I'm closing the connection when eahc object is finished with it, the cursors which it opens in the database seem to stay around for quite some time, only disappearing when I shut the application down. How can I ensure that i don't get to the stage that the open_cursors variable is exceeded? Is there a way of saying ordering a connection to close all cursors associated with what it just did?

Ta,
SSM Received on Thu Jan 15 2004 - 10:38:56 CST