title: Spring: Unable to determine the correct call signature - multiple procedures/functions/signatures
body: <p>I'm trying to get data from an Oracle stored procedure. The problem is that in our database there is a function and a procedure with the same name and same parameters.</p>
  
  <p>When I try to call it:</p>
  
  <pre><code>@Autowired
      public void setDataSource (@Qualifier("dataSource") DataSource dataSource) {
          JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
          jdbcTemplate.setResultsMapCaseInsensitive(true);
          this.functionGetSomeCode = new SimpleJdbcCall(jdbcTemplate)
                  .declareParameters(new SqlOutParameter("RETURN", OracleTypes.NUMBER))
                  .withFunctionName("get_some_code").withSchemaName("XXX").withCatalogName("some_pkg");
      }
  
      public Integer getSomeCode (String incoming) {
          SqlParameterSource incomingParameters = new MapSqlParameterSource().addValue("incoming", incoming);
          return functionGetSomeCode.executeFunction(Integer.class, incomingParameters);
      }
  </code></pre>
  
  <p>I get an exception:</p>
  
  <pre><code>springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - multiple procedures/functions/signatures
  </code></pre>
  
  <p>Is there a way to handle this situation without asking the DBA to rename the function / procedure to something different?</p>