Re: Oracle Cursors with .Net
Date: Wed, 4 Jun 2008 23:20:09 +0100
"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 PortasReceived on Wed Jun 04 2008 - 17:20:09 CDT