Re: Problem catching multiple values - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Problem catching multiple values
Date
Msg-id Pine.BSO.4.56.0505250146170.1172@leary.csoft.net
Whole thread Raw
In response to Problem catching multiple values  (hiuguis@iteso.mx)
Responses Re: Problem catching multiple values
List pgsql-jdbc

On Tue, 24 May 2005 hiuguis@iteso.mx wrote:

>     Im having an problem when I try to catch multiple values from an SETOF
> float8 pgsql function invoked from java. This is the message that I get:

CallableStatements cannot be used for SETOF functions, only refcursor
returning functions.  It is best to call this with a normal
PreparedStatement or Statement that returns a ResultSet in the standard
fashion:  SELECT * FROM mysrf();

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Translation update: pl_PL
Next
From: Markus Schaber
Date:
Subject: Re: ASCII to UNICODE conversion problems