Re: INOUT parameter problem.

[Roland Bouman]

I found a similar result.

I think it's a bug. Funny thing is, if you reverse the parameters, and make inputParam INOUT too, it does seem to work --> (slightly modified)

CREATE PROCEDURE demoSp(
INOUT inputParam VARCHAR(255)
,INOUT inOutParam INT
)
BEGIN
DECLARE z INT;
SET z = inOutParam + 1;
SET inOutParam = z;
SELECT inputParam;
SELECT CONCAT('zyxw', inputParam)
into inputParam
;
END
//

<--

java.sql.CallableStatement cStmt = connection.prepareCall("{call test.demoSp(?, ?)}");
cStmt.registerOutParameter("inputParam", java.sql.Types.VARCHAR);
cStmt.registerOutParameter("inOutParam", java.sql.Types.INTEGER);
cStmt.setString("inputParam", "hello");
cStmt.setInt("inOutParam", 4);
cStmt.execute();
System.out.println(cStmt.getString("inputParam"));
System.out.println(cStmt.getInt("inOutParam"));


gives me this output:

zyxw4
5

So maybe it's time to write a bug report. Will you? If not, post back and I will. If you do, post back so i can subscribe.

TIA, roland