Skip site navigation (1) Skip section navigation (2)

Stored proc returns RECORD & JDBC

From: "Igor Borisovsky" <igor(at)datanaut(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Stored proc returns RECORD & JDBC
Date: 2005-03-23 21:12:17
Message-ID: 200503232111.j2NLBDC30590@alexru.adsl.kis.ru (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi.

As you know we have to invoke the stored proc which returns RECORD in the
following manner:

Select * from func() as (a datatype1, b datatype2.);

There is no problem to execute such statement as PreparedStatement.

But I need to use only CallableStatement.

Does anyone know how to do it?

Thanks.

 

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-03-23 21:49:01
Subject: Re: Stored proc returns RECORD & JDBC
Previous:From: Kris JurkaDate: 2005-03-23 20:21:46
Subject: Re: moveToCurrentRow causes ArrayIndexOutOfBoundsException

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group