=?GB2312?B?1cW6o7fl?= <roxetter(at)gmail(dot)com> writes:
> And i call function a by jdbc:
> ...
> conn.setAutoCommit(false);
> CallableStatement cs = conn.prepareCall("{ call a( ?, ? ) }");
> cs.registerOutParameter(1, Types.INTEGER);
> cs.registerOutParameter(2, Types.OTHER);
> cs.execute();
That's not the approved syntax for using OUT parameters in Postgres.
It's possible that JDBC would do something under-the-hood to make it
look like it works, but you'd be best off asking on pgsql-jdbc about
whether they do or not.
regards, tom lane