Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Implicit and Explicit cursors

Re: Implicit and Explicit cursors

From: Cassandra <sharpe_at_mindspring.com>
Date: Mon, 16 Apr 2001 22:14:33 -0400
Message-ID: <9bg90j$aj8$1@nntp9.atl.mindspring.net>

The database Connection object is returned to the connection pool. This doesn't close the connection, it just returns it to the pool so that it can be reused. Therefore it appears that some implicit cursors are left open.

Any other ideas or suggestions?

"Galen Boyer" <galenboyer_at_yahoo.com> wrote in message news:uitk4eazl.fsf_at_yahoo.com...
> On Mon, 16 Apr 2001, cassandra_sharpe_at_merck.com wrote:
>
> > And, because we don't close the database Connection
> > object.. .these implicit cursors are never closed.
>
> Usually, with pools, closing the connection sends it back to the
> pool, so maybe you could just do that?
> --
> I don't want to be the rock. Yeah, okay, what do you want to be?
> I want to be the piece of glass.
Received on Mon Apr 16 2001 - 21:14:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US