Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Calling a stored procedure with a custom return type
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Brad Larson <bklarson+postgres(at)gmail(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Calling a stored procedure with a custom return type
- Date: Thu, 25 Oct 2007 18:47:48 -0400 (EDT)
On Thu, 25 Oct 2007, Brad Larson wrote:
I'm sorry if this is already documented elsewhere; I've googled around
and searched the jdbc source without any luck. I have a stored
procedure (PL/pgSQL) which uses a custom return type of the form:
How can I call this from JDBC? I can call it with a
prepareStatement("select login( ?, ?, ?, ? )");
but then the results are all returned as 1 string, of the form "(int,
string, t, t)", which of course isn't ideal. I also tried
SELECT * FROM login(?,?,?,?); Kris Jurka
- References:
- Calling a stored procedure with a custom return type
- From: Brad Larson
- Calling a stored procedure with a custom return type
- Prev by Date: Re: Potential inconsistency in handling of timestamps
- Next by Date: Re: multiple connections to db over jsp
- Previous by thread: Calling a stored procedure with a custom return type
- Next by thread: Error in JDBC with Java Sun Studio Creator 2
- Indexes: