Is the following legal:

if (<condition>) {
        exec sql declare cur cursor for
                select name, nr from table where nr < 10;
}
else {
        exec sql declare cur cursor for
                select name, nr from table where nr >= 10;
}


That is declaring one cursor in two different ways? Oracle cannot do that.
We can, though. Shall I disable this (and remove my last changes) or is this
a good feature (as I think it is) and we keep it? Only disadvantage is that
the declare tarnslates into a C statement and is not really a declaration
anymore.

Michael
-- 
Dr. Michael Meskes		meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

Wed, 5 Aug 1998 21:18:40 +0200
"Dr. Michael Meskes" <meskes@online-club.de>
Declare Cursor question again
> Shall I disable this (and remove my last changes) or is this
> a good feature (as I think it is) and we keep it? Only disadvantage is 
> that the declare tarnslates into a C statement and is not really a 
> declaration anymore.

On my Ingres box, the "declare cursor" statements could appear up in or
near the declarations portion of the program or routine. Wouldn't
associating this statement with executable code put limitations on
statement location which other systems (and perhaps the standard) do not
see?

                        - Tom

Thu, 06 Aug 1998 06:17:18 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] Declare Cursor question again
On Thu, Aug 06, 1998 at 06:17:18AM +0000, Thomas G. Lockhart wrote:
> On my Ingres box, the "declare cursor" statements could appear up in or
> near the declarations portion of the program or routine. Wouldn't
> associating this statement with executable code put limitations on
> statement location which other systems (and perhaps the standard) do not
> see?

Yes. In Oracle you can put it outside a function. 

Michael
-- 
Dr. Michael Meskes		meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

Thu, 6 Aug 1998 22:11:11 +0200
"Dr. Michael Meskes" <meskes@online-club.de>
Re: [HACKERS] Declare Cursor question again