On Sun, Jun 13, 1999 at 07:24:52PM -0500, Brent Waldrop wrote:
> EXEC SQL declare democursor cursor for
> select fname,lname
> into :fname, :lname
> from employee
> where lname < :oneline;
> ---it bombs at the line with "into" in it saying there is a parse error
You don't use INTO clause in DECLARE section.
You have to place in into
EXEC SQL FETCH IN democursor
INTO :fname, :lname
> and when i do this EXEC SQL fetch democursor;
> --it tells me that there is another parse error on this line
See above.
GL, Ivo.