Re: ecpg weird behavior

...
> > EXEC SQL FETCH curs_currency;
> Anyone out there with more knowledge about standards? I thought this was
> not standard at all.

From what I can tell from my SQL99 maybe-docs we have all shared in the
past on this list, the INTO is required to travel with the FETCH
statement:
         ::=             FETCH [ [  ] FROM ]              
         ::=                            | 
         ::=             INTO  [ {   }... ]
         ::= 
         ::=             INTO [ SQL ] DESCRIPTOR 

hth
                    - Thomas

btw, I was working for the first time with ecpg and was very impressed.
A company porting from Oracle ran into very few issues. Their existing
code *did* have an Oracle extension to use a cursor to select multiple
rows into variables declared as arrays. Have you run into this syntax or
thought about what it would take to implement it?