I am using Spring JDBC and I want to call a stored procedure which will have only 1 String argument. My problem is that the stored procedure name is a user input.
How to avoid SQL injection while doing this?
I am using Spring Boot and the stored procedure name is a user input and I don't have a defined entity so I am not using jpa respository.
I am using Single store DB
I tried the following but it gives me SQL Injection vulnerabilities.
String callStatement = String.format("ECHO %s (?)", procedureName);
Map<String, Object> res = jdbcTemplate.queryForMap(callStatement, arg);