Re: Cursors
- From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
- To: lyallbarbour@xxxxxxxxxxxxxxx
- Date: Wed, 23 Dec 2009 13:50:05 -0500
My understanding is that if you are talking about a cursors within
pl/sql procedures, as the block exists, the cursors are closed for you
automatically. There are a number of innovations that have occurred
over the last few versions in this area with cursor caching and what
not. For a good discussion see:
http://www.gennick.com/open_cursors.html
On Wed, Dec 23, 2009 at 1:43 PM, <lyallbarbour@xxxxxxxxxxxxxxx> wrote:
> From what i've always known is you do not have to "close" a cursor when you
> loop it with a FOR LOOP. But if you explicitly say OPEN, FETCH... etc, then
> you need a CLOSE. That's just off the top of my head, though.
> Lyall
>
>
> -----Original Message-----
> From: Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>
> To: oracle-l@xxxxxxxxxxxxx
> Sent: Wed, Dec 23, 2009 1:31 pm
> Subject: Cursors
>
> All,
> First off, Merry Christmas, Happy Hanukah, Happy Kwanza, etc… to
> one and All.
> I'm trying to track down a perception that some of our developers
> have that there is no longer, post Oracle 10g R1, a need for their
> applications to close cursors. I've searched the Oracle docs, Metalink, and
> Google to no avail. Anyone else hear about this "feature"?
> Dick Goulet
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
> 900 Chelmsford St, Suite 310
> Lowell, MA 01821
> 978.614.2857
> Richard.Goulet@xxxxxxxxxxx
> The information transmitted in this communication is intended only for the
> person or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please destroy any copies, contact the sender and
> delete the material from any computer.
>
--
Rumpi Gravenstein
--
//www.freelists.org/webpage/oracle-l
Other related posts:
