title: Error while calling stored procedure from Spring Data
body: <p>I tried several different ways to access to my stored procedure via my spring boot application but I have always Errors like : </p>
  
  <blockquote>
    <p>InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet</p>
  </blockquote>
  
  <p>or</p>
  
  <blockquote>
    <p>Caused by: java.sql.SQLException: ORA-06550: line 1, column 7:
    PLS-00201: identifier 'MY_STORED_PROCEDURE_NAME' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored</p>
  </blockquote>
  
  <p>I tried :</p>
  
  <pre><code> StoredProcedureQuery procedureQuery = entityManager.createStoredProcedureQuery("MY_STORED_PROCEDURE_NAME");
          procedureQuery.registerStoredProcedureParameter("paramOut", Object.class, ParameterMode.OUT);
          procedureQuery.execute();
          procedureQuery.getOutputParameterValue("paramOut");
  
  @Transactional
  @Procedure(procedureName= "MY_STORED_PROCEDURE_NAME" )
  Object getNextNumber();
  
  @Query(value = "{call MY_STORED_PROCEDURE_NAME()}", nativeQuery = true)
  @Transactional
  Object getNextNumber();
  </code></pre>
  
  <p>but always  it seems he can't reach my stored procedure in my DB : 
  I added grand grant execute on ... to ... but that doesn't solve the problem</p>
  
  <p>any idea, please  </p>