Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!r66g2000hsg.googlegroups.com!not-for-mail From: Ed Prochak Newsgroups: comp.databases.oracle.server Subject: Re: Oracle Cursors with .Net Date: Fri, 6 Jun 2008 05:28:30 -0700 (PDT) Organization: http://groups.google.com Lines: 29 Message-ID: <2c4f4af4-941c-4e19-a113-74725ca22d61@r66g2000hsg.googlegroups.com> References: <2982ab81-deb2-4c34-8832-d49a4c005b4c@z16g2000prn.googlegroups.com> NNTP-Posting-Host: 206.54.145.254 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1212755310 27973 127.0.0.1 (6 Jun 2008 12:28:30 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 6 Jun 2008 12:28:30 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: r66g2000hsg.googlegroups.com; posting-host=206.54.145.254; posting-account=3ty6FAkAAACYEfch20jQ1ZACFatw-Vdx User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14,gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:445378 X-Received-Date: Fri, 06 Jun 2008 08:28:30 EDT (text.usenetserver.com) On Jun 4, 6:20 pm, "David Portas" wrote: > "Ed Prochak" wrote in message > > news:cb000581-f148-4d8c-8523-e8b6bf533d1b@z66g2000hsc.googlegroups.com... > > > > > ANY SELECT statement in ANY database opens a cursor. That cursor may > > be explicit or implicit, but it exists either way. This comes straight > > out of the SQL standard. > > Why do you say this comes from the SQL standard? The standard says that > cursors must be created with a DECLARE statement. As far as I'm aware there > is no such thing as an implicit cursor in standard SQL. No such reference in > the 1999 or 2003 docs anyway. > > -- > David Portas Maybe I should not have said straight out of the standards. I only have a reference (Martin Gruber's Instant Reference) It defines a cursor as an object to hold the results of a query for processing. But I honestly think the exact same operation of open, fetch, close must happen internally for any select statement, on its own or within a CURSOR statement. So I'll change my defense to appeal to the Oracle documentation. 8^) Ed