CallableStatements and OUT Parameters

Derby supports OUT parameters and CALL statements that return values, as in the following example:

CallableStatement cs = conn.prepareCall(
   "? = CALL getDriverType(cast (? as INT))"
cs.registerOutParameter(1, Types.INTEGER);
cs.setInt(2, 35);
cs.executeUpdate();

Note: Using a CALL statement with a procedure that returns a value is only supported with the ? = syntax.