Re: Calling PGSQL Stored function thru JDBC

On Thu, 29 Jul 2004, Nick Selva wrote:

> [my CallableStatement doesn't work.]

You have misnumbered your parameters.  You want to do cs.setString(2, "P")
because that matches with the second "?", and cs.registerOutParameter(1,
Types.VARCHAR) because that is the out parameter.  You also may need to
say "{ ? = call get_state(?) }", note the equal sign.

Kris Jurka