On Sat, Apr 28, 2007 at 10:26:15AM -0400, Andrew Jarcho wrote:
> Michael Fuhr wrote:
> >Could you post a simple example that shows what you're trying to
> >do? Please describe what you'd like to happen and what actually
> >does happen.
> Thank you very much Michael for your reply. Here's an example:
Please copy the mailing list on replies so others can contribute
to and learn from the discussion.
> /* a problem here */
> EXEC SQL DECLARE c_1 (inval integer) CURSOR FOR SELECT foo(:caseID);
EXEC SQL DECLARE c_1 CURSOR FOR SELECT foo(:caseID);
> EXEC SQL OPEN c_1 (:caseID);
EXEC SQL OPEN c_1;
Also, the code you sent me privately declares and refers to an
indicator variable (result_ind) but doesn't set it in the FETCH
statement. If your compiler didn't warn about that then consider
turning on whatever flags would print such warnings (e.g., -Wall
if you're using gcc).
In response to
pgsql-novice by date
|Next:||From: Andrew Jarcho||Date: 2007-04-29 19:39:27|
|Subject: Re: call stored function from ecpg w/cursor|
|Previous:||From: Jessica Fendos||Date: 2007-04-29 06:12:29|
|Subject: PGSQL Query|