i have a java spring boot module that call a PL/SQL stored procedure , it’s work perfectly on a user db but not when a use a another user , the error a bad sql grammar error like this :
java.sql.SQLException: ORA-06550: Ligne 1, colonne 7 : PLS-00306: numéro ou types d'arguments erronés dans appel à 'S_TAUXAVAILABLE' ORA-06550: Ligne 1, colonne 7 : PL/SQL: Statement ignored
i am sure that the parameters are good ( because it’s work when a change the user db ) , i am using jdbc 6 with spring boot 3.0.2.
<code> @Autowired
private DataSource dataSource;
// Permet d'appeler la base de données
public Map<String, Object> callStoredProcedure(String packageName, String procedureName, Map<String, Object> parameters) {
SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(dataSource)
.withCatalogName(packageName)
.withProcedureName(procedureName);
SqlParameterSource in = new MapSqlParameterSource(parameters);
return simpleJdbcCall.execute(in);
}
</code>
<code> @Autowired
private DataSource dataSource;
// Permet d'appeler la base de données
public Map<String, Object> callStoredProcedure(String packageName, String procedureName, Map<String, Object> parameters) {
SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(dataSource)
.withCatalogName(packageName)
.withProcedureName(procedureName);
SqlParameterSource in = new MapSqlParameterSource(parameters);
return simpleJdbcCall.execute(in);
}
</code>
@Autowired
private DataSource dataSource;
// Permet d'appeler la base de données
public Map<String, Object> callStoredProcedure(String packageName, String procedureName, Map<String, Object> parameters) {
SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(dataSource)
.withCatalogName(packageName)
.withProcedureName(procedureName);
SqlParameterSource in = new MapSqlParameterSource(parameters);
return simpleJdbcCall.execute(in);
}
have a good day thank you.
i tired with another user db (same db ) and it’s work so i think that it’s not the parameters the probleme , i tried with jdbc template instead of datasource it’s the same problem