Skip to main content

Stored procedures

Passing and receiving parameters​

Use IN/OUT/INOUT parameters for scalar values. For example, create a procedure that adds two numbers:

CREATE PROCEDURE add_numbers(IN a INT, IN b INT, INOUT result INT)
BEGIN SET result = a + b; END

Send the complete definition as one statement. Then bind the input values and the output parameter:

Map<String, Object> result = jdbc.call(
        "CALL add_numbers(?, ?, ?)",
        new Object[] { 10, 5, SqlArg.asInOut("result", 0, Types.INTEGER) });
Integer sum = (Integer) result.get("result"); // 15

Named parameters, parameter type declarations, and multiple scalar outputs are also supported. JDBC REF_CURSOR output mapping is not supported on this path. To receive rows returned by a procedure, use result-set rules, not a REF_CURSOR parameter.