Re: Problem catching multiple values

Thank you Kris. I had made the changes and now its working fine. Thanks again.


Mensaje citado por Kris Jurka <books@ejurka.com>:
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>