But, how can I do ? I have to recall the same routine many times. I tried to prepare and declare the cursor inside the routine but when I compile with ecpg I receive the error Cursor already defined. Maurizio . ----- Original Message ----- From: "Michael Meskes" <[EMAIL PROTECTED]> To: "Maurizio" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 08, 2000 12:39 PM Subject: Re: [INTERFACES] 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 > [EMAIL PROTECTED] > Go SF 49ers! Go Rhein Fire! > Use Debian GNU/Linux! Use PostgreSQL!
