Обсуждение: ecpg: using cursor returned from a stored function
Hello to all, I he some stored functions that returns a refcursor and I need to use this cursor In my ECPG programs. I've serached for documentation but I don't found anything about it so: How I can do it? Looking in the include files of PG I don't found a cursor data type so I don't have any ideas on how proceed. Thank you, Gaetano Sferra ____________________________________________________________ Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione. Abbonati subito su http://www.libero.it
Am Dienstag, 9. November 2004 12:39 schrieb Gaetano Sferra: > I he some stored functions that returns a refcursor and I need to use this > cursor In my ECPG programs. Cursors in ECPG are managed differently, so I strongly suspect that your idea won't work. -- Peter Eisentraut http://developer.postgresql.org/~petere/
---------- Initial Header ----------- From : "Peter Eisentraut" peter_e@gmx.net To : "Gaetano Sferra" gaesferr@libero.it Cc : "pgsql-interfaces" pgsql-interfaces@postgresql.org Date : Tue, 9 Nov 2004 17:35:55 +0100 Subject : Re: [INTERFACES] ecpg: using cursor returned from a stored function > Am Dienstag, 9. November 2004 12:39 schrieb Gaetano Sferra: > > I he some stored functions that returns a refcursor and I need to use this > > cursor In my ECPG programs. > > Cursors in ECPG are managed differently, so I strongly suspect that your idea > won't work. > > -- > Peter Eisentraut Well, so it is impossible to use cursors returned by a stored function in ECPG? There are work arounds? Please give me an exausthive reply if you can. Thank you Gaetano Sferra > http://developer.postgresql.org/~petere/ > ____________________________________________________________ Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione. Abbonati subito su http://www.libero.it
---------- Initial Header ----------- From : "Peter Eisentraut" peter_e@gmx.net To : "Gaetano Sferra" gaesferr@libero.it Cc : "pgsql-interfaces" pgsql-interfaces@postgresql.org Date : Tue, 9 Nov 2004 17:35:55 +0100 Subject : Re: [INTERFACES] ecpg: using cursor returned from a stored function > Am Dienstag, 9. November 2004 12:39 schrieb Gaetano Sferra: > > I he some stored functions that returns a refcursor and I need to use this > > cursor In my ECPG programs. > > Cursors in ECPG are managed differently, so I strongly suspect that your idea > won't work. > > -- > Peter Eisentraut Well, so it is impossible to use cursors returned by a stored function in ECPG? There are work arounds? Please give me an exausthive reply if you can. Thank you Gaetano Sferra ____________________________________________________________ Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione. Abbonati subito su http://www.libero.it