Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!think.com!paperboy!snorkelwacker.mit.edu!hsdndev!cmcl2!uupsi!dlogics!hermes!dlm
From: dlm@hermes.dlogics.com
Newsgroups: comp.databases
Subject: Re: Oracle CURSORS useless ?
Message-ID: <663.286d50e7@hermes.dlogics.com>
Date: 30 Jun 91 09:32:55 GMT
References: <1991Jun26.033043.22948@sunaus.oz> <25731@well.sf.ca.us>
Organization: Datalogics, Inc., Chicago, IL
Lines: 15

I still think this thread is missing the point. 

The original question was: "how do i update while i am in a fetch loop; if i 
update and commit, the cursor closes!".  So everyone gets into a discussion
of when cursors close or don't close.

The answer is: "There is no need to commit until you are done with the fetch".
That way, the problem with unexpectedly closed cursors becomes moot, and the
guy can fix his code and get on with his life.

I am pretty sure the folks at oracle will agree with me on this. ;-)
-- 
Dave Mausner, Sr Tech Consultant / Datalogics Inc / Chicago IL / 312-266-4450
                        dlm@hermes.dlogics.com
            "Don't talk about it -- just show me the code!"