CallableStatement cstmt = connection.prepareCall("{call myProcedure(?)}"); cstmt.setDouble(1, 3.14); ResultSet rs = cstmt.executeQuery();
CallableStatement cstmt = connection.prepareCall("{call myProcedure(?,?,?)}"); cstmt.setDouble(1, 10.0); cstmt.setDouble(2, 20.0); cstmt.setDouble(3, 30.0); ResultSet rs = cstmt.executeQuery();In this example, we are setting three double values as parameters for a stored procedure using a callable statement. Package Library: java.sql