Re: JDBC parameter binding not working for PL/PGSQL block JDBC3 Version 9.0-801

On 28 April 2011 07:35, Brady S Edwards <brady.s.edwards@seagate.com> wrote:

> When trying to setString(1,?) where the ? is in a pl/pgsql block I get an
> error.

? is not considered a parameter marker if it occurs inside a literal string.
The pl/pgsql code in your case is one big literal string (delimited by $$)

It's just the same case as "SELECT 'should this be a parameter?'",
which is a query that takes no parameters despite happening to contain
a ? character.

Oliver