Re: USE OF CURSORS IN ECPG

On Tue, Nov 07, 2000 at 05:52:00PM +0100, Maurizio wrote:
> I'm just starded using ecpg and I have some problem with cursors.
> ...
> exec sql prepare stmtunimpianto from :query;
> .
> .
> exec sql commit;
> ...
> If I rem the commit all works fine but if I execute the commit the cursor was deleted and I receive some errors.
>
> At open cursor : sqlca.sqlcode = -230 Invalid statement namei in line ......
> at fetch : NOTICE : PerformPortalFetch: portal "cur_unimpianto" not found

No surprise here as ending a transaction forces a deallocation of all
prepared statements. AFAIK that's what the standard says.

Michael

--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!