Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!dali.cs.montana.edu!caen!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!markj
From: markj@informix.com (Mark Jeske(Chicago Consultan)t)
Newsgroups: comp.databases
Subject: Re: Oracle CURSORS useless ?
Message-ID: <1991Jun26.234724.18956@informix.com>
Date: 26 Jun 91 23:47:24 GMT
References: <1991Jun26.033043.22948@sunaus.oz>
Sender: news@informix.com (Usenet News)
Organization: Informix Software, Inc.
Lines: 14

In article <1991Jun26.033043.22948@sunaus.oz> par@sirius.Aus.Sun.COM writes:
>
>nigel@cnw01.storesys.coles.oz.au (Nigel Harwood) writes:
>
>Well, it does pose a problem for the developer - but you can some consolation
>in knowing that this limitation isn't just Oracle's.  Every commercial SQL
>DBMS I've ever seen closes all open cursors [SQL/DS, DB2, Ingres ...] when
>a commit is issued.
>

Not Informix.  In our 4.0 product you can declare a cursor with hold
and it won't be closed during a commit.

mark