Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] esql\c documentation

From: Ivo Simicevic <ivo(at)ultra(dot)hr>
To: Brent Waldrop <waldrop_brent(at)hotmail(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] esql\c documentation
Date: 1999-06-14 11:34:21
Message-ID: 19990614133421.A10311@ultra.hr (view raw or flat)
Thread:
Lists: pgsql-interfaces
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.

In response to

pgsql-interfaces by date

Next:From: Georg RitterDate: 1999-06-14 14:25:33
Subject: JDBC Driver 6.5 where to get?
Previous:From: ole-jorgen.bjerveDate: 1999-06-14 10:56:02
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group