Re:bug in cursor FOR loops?

From: <dgoulet_at_vicr.com>
Date: Mon, 28 Jan 2002 13:44:03 -0800
Message-ID: <F001.003FDD5C.20020128134137@fatcity.com>

Paul,

None that I've noticed & I have one that gets executes some 100,000 times.

Dick Goulet

____________________Reply Separator____________________
Author: Paul Baumgartel <treegarden_at_yahoo.com>
Date:       1/28/2002 1:15 PM

Is there a bug (8.1.7.2.0 on HP-UX) in the implementation of cursor FOR loops, such that the cursor is not closed upon loop exit? If a function containing such a loop is called many times, eventually the session returns a "too many open cursors" error; an attempt to close the cursor manually after the loop returns "invalid cursor". I've searched MetaLink (including bug database) and haven't found anything.

TIA, Paul Baumgartel

Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: treegarden_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------