Re: Problem catching multiple values

From: Kris Jurka <books(at)ejurka(dot)com>
To: hiuguis(at)iteso(dot)mx
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem catching multiple values
Date: 2005-05-25 06:48:53
Message-ID: Pine.BSO.4.56.0505250146170.1172@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 24 May 2005 hiuguis(at)iteso(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Markus Schaber 2005-05-25 11:25:52 Re: ASCII to UNICODE conversion problems
Previous Message Kris Jurka 2005-05-25 06:25:48 Re: Translation update: pl_PL