PROCEDURE InsertRating(member_id IN NUMBER, product_id IN NUMBER, value IN NUMBER)
    AS       
    
    rate_id NUMBER(10) := 0;
    
    BEGIN
        
        SELECT MAX(rating_id) INTO rate_id FROM Rating;
        
        rate_id := rate_id + 1;
        
        INSERT INTO Rating VALUES(rate_id, member_id, product_id, value);

    END InsertRating;

...
int MEMBER_ID = 5;
int PRODUCT_ID = 2;
int value = 1;
...
_callablestatement = _connection.prepareCall("{call pkgDynamicSQL.InsertRating(?,?,?)}");
_callablestatement.setInt(1, MEMBER_ID);
_callablestatement.setInt(1, PRODUCT_ID);
_callablestatement.setInt(1, value);
_callablestatement.executeUpdate();

java.sql.SQLException: В индексе отсутствует параметр IN или OUT:: 2
	at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2076)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4790)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
	at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:5661)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)