fetch in embedded sql

From: "Heinrich Retzlaw" <hretzlaw(at)etm(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: fetch in embedded sql
Date: 2001-05-23 06:55:59
Message-ID: 9efmu2$3rl$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello,
i have written the following method for c++

bool DB::getPresentations(Presentations &pr)
{
exec sql begin declare section;
int rID;
char pre[20];
exec sql end declare section;

rID = pr.roomID;

exec sql BEGIN TRANSACTION;
exec sql DECLARE cur CURSOR FOR
SELECT Presantation
FROM Presantations
WHERE RoomID=:rID;

exec sql OPEN cur;

// here
exec sql FETCH FORWARD 1 IN cur INTO :pre;

// and here
exec sql CLOSE cur;
exec sql COMMIT TRANSACTION;
}

if i start this method i get the following error belonging to the comments
"here" and "and here" in the code above

NOTICE: current transaction is aborted, queries ignored until end of
transaction block
NOTICE: current transaction is aborted, queries ignored until end of
transaction block

if i do the begin, declare cursor and fetch statement manually in the psql
database there is no error
thanks for every answer
best regards heinrich retzlaw

Browse pgsql-general by date

  From Date Subject
Next Message J.H.M. Dassen Ray 2001-05-23 07:49:56 Re: pg_dump fails, data integrity imperfect
Previous Message Eric G. Miller 2001-05-23 06:44:35 Re: initdb doesn't work with cygwin 1.3.1?