RE: Cursors

From: Goulet, Richard <>
Date: Wed, 23 Dec 2009 13:47:38 -0500
Message-ID: <>

My understanding of the loop processing, but we're talking Java here so most bets are off.  

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International  

[] On Behalf Of
Sent: Wednesday, December 23, 2009 1:43 PM To:
Subject: Re: Cursors

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 <> To:
Sent: Wed, Dec 23, 2009 1:31 pm
Subject: Cursors


        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
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.

Received on Wed Dec 23 2009 - 12:47:38 CST

Original text of this message