Re: [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Corradini, Carlos" <CCorradini(at)correoargentino(dot)com(dot)ar>, pgsql-jdbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Cc: books(at)ejurka(dot)com
Subject: Re: [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA
Date: 2015-12-10 21:25:28
Message-ID: 5669EDC8.9070805@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On 12/10/2015 05:38 AM, Corradini, Carlos wrote:
> Dear Gurus :
>
> First let me say hello from Buenos Aires, Argentina. I
> took this emails addresses from internet ( page www.postgresql.org
> <http://www.postgresql.org> )
>
> Now I will try to explain which is my problem ( excuse
> my poor level of English, please ). I have a Java application that must
> read a data provided by two ( 2 ) cursors returned by a function stored
> in a database. I know to retrieve data if the function have one ( 1 )
> cursor, but with two I can’t. I will very pleased if any of you, in your
> free time of course, can explain me how, inside the java program, after
> connecting via jdbc to the database, I extract the data returned by the
> second cursor.

Can you provide the function code that is returning the cursors?

>
> Many thanks ( muchas gracias ) and I wait for yours
> replies as soon as you can.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-12-10 21:29:00 Re: Loggingt psql meta-commands
Previous Message David G. Johnston 2015-12-10 21:24:22 Re: Loggingt psql meta-commands

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kevin Grittner 2015-12-10 22:06:06 Re: [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA
Previous Message Corradini, Carlos 2015-12-10 13:38:10 [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA