RE: Cursors

The Gist of the article referred to by the link seems to be that you should explicitly close your cursors in pl/sql since Oracle will do so for you in only limited circumstances.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rumpi Gravenstein Sent: Wednesday, December 23, 2009 1:50 PM To: lyallbarbour_at_sanfranmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Cursors

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_at_sanfranmail.com> 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_at_parexel.com>
> To: oracle-l_at_freelists.org
> 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_at_PAREXEL.COM
> 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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l