Date: Wed, 10 Nov 2004 15:22:43 +0100
Message-Id: <I6YVXV$CE640DCE042E1D8D3D2F5B3582511133@libero.it>
Subject: Re: ecpg: using a cursor returned by a stored function
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
From: "Gaetano Sferra" <gaesferr@libero.it>
To: "pgsql-interfaces" <pgsql-interfaces@postgresql.org>

Hello,
I've found a solution, may be it isn't "chic" and may be it is a =
ECPG bug but it
work.
Follow this example:

-- This is the stored fun=
ction
CREATE FUNCTION myfunc(refcursor) RETURNS refcursor AS'
DECLARE=0D
=
ref ALIAS FOR $1;
BEGIN
OPEN ref FOR SELECT * FROM mytable;
RETURN ref=
;
END;

-- This is a piece of ECPG that call the stored function above=

EXEC SQL SELECT myfunc('mycursor');
while (sqlca.sqlcode !=3D 100)
{=0D
=
EXEC SQL FETCH mycursor INTO ... ... ;
... ... ...
}
EXEC SQL CLOSE my=
cursor;

compiling the above piece of code the ECPG compiler will outpu=
t:
filename.pgc:xx: ERROR: trying to acces an undeclared cursor mycursor=


but it will produce a complete filename.c output anyway and compiling=
 it with cc
or gcc you
will the SELECT output.
It isn't nice but work =
:)

If you have any other ideas please post it to me, thank you.
Gaeta=
no Sferra
=0A=0A=0A=0A__________________________________________________=
__________=0ALibero ADSL: navighi gratis a 1.2 Mega, senza canone e costi=
 di attivazione. =0AAbbonati subito su http://www.libero.it =0A