From: Maurizio <maurizio.c@libero.it>
To: Michael Meskes <meskes@postgresql.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [INTERFACES] USE OF CURSORS IN ECPG
Date: Thu, 9 Nov 2000 14:49:29 +0100
Message-ID: <004301c04a53$f98ecc00$7394fea9@maurizio> (raw)
References: <001101c048db$38a74d60$7394fea9@maurizio>
<20001108123942.A7369@feivel.fam-meskes.de>
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" <meskes@postgresql.org>
To: "Maurizio" <maurizio@dreamtech-it.com>
Cc: <pgsql-interfaces@postgresql.org>
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
> Michael@Fam-Meskes.De
> Go SF 49ers! Go Rhein Fire!
> Use Debian GNU/Linux! Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: maurizio.c@libero.it, meskes@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [INTERFACES] USE OF CURSORS IN ECPG
In-Reply-To: <004301c04a53$f98ecc00$7394fea9@maurizio>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox