Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!uwm.edu!linac!unixhub!slacvm!ian
From: IAN@SLACVM.SLAC.STANFORD.EDU
Newsgroups: comp.databases
Subject: Re: Oracle CURSORS useless ?
Message-ID: <91179.094222IAN@SLACVM.SLAC.STANFORD.EDU>
Date: 28 Jun 91 17:42:22 GMT
References: <1991Jun27.230131.2358@world.std.com>
Organization: Stanford Linear Accelerator Center
Lines: 11

Oracle has SAVEPOINT as well.  An Informix employee mentioned using the
hold option.  Oracle has a hold cursor and a release cursor option.  I
don't know whether they will solve the commit problem.  I thought they
were used so that after a cursor was closed you could open the cursor
again with a different value in the predicate.  You didn't need to
redeclare the cursor.  In fact Oracle is not ansi standard in that it
allows you to re-open a cursor without closing it first, (with the
default option settings).  What exactly does hold cursor mean to Informix


                  Ian MacGregor [Stanford Linear Accelerator Center]