Xref: alice comp.databases.oracle.server:42133
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!cam-news-hub1.bbnplanet.com!cam-news-feed3.bbnplanet.com!news.gtei.net!sandoz-bh.sandgway.com!not-for-mail
From: Stephen Hirsch <Stephen.Hirsch@pharma.novartis.com>
Newsgroups: comp.databases.oracle.server
Subject: Not Closing Oracle 8 Cursors
Date: Wed, 03 Mar 1999 14:31:38 -0500
Organization: Novartis Pharmacueticals
Lines: 15
Message-ID: <36DD8E1A.721F@pharma.novartis.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.02 (WinNT; I)

Hi,

I couldn't find this in the documentation. I apologize if I overlooked
it.

Due to performance considerations in Oracle 7, we were leaving cursors
open until the session terminated, which then automatically closed them.
My understanding is that session termination in Oracle 8 does not
automatically close open cursors.

Is that true? If so, what would be the implications?

Many thanks in advance,

Steve Hirsch