Re: Oracle Cursors with .Net

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Wed, 4 Jun 2008 23:20:09 +0100
Message-ID: <C72dnevlhPSJiNrVnZ2dneKdnZydnZ2d@giganews.com>


"Ed Prochak" <edprochak_at_gmail.com> wrote in message news:cb000581-f148-4d8c-8523-e8b6bf533d1b_at_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
Received on Wed Jun 04 2008 - 17:20:09 CDT

Original text of this message