title: Quarkus JPA Postgres Stored Procedure call - use CALL Error
body: <p>I implemented a PostgresSQL stored procedure call from Quarkus JPA in the way that Davide suggested here:</p>
  <p><a href="https://stackoverflow.com/questions/67027182/quarkus-rest-api-with-hibernate-panache-endpoints-querying-postgres-stored-pro">Quarkus REST API with Hibernate/Panache - Endpoints querying Postgres Stored Procedure</a></p>
  <p>However calling the stored procedure always fails with the following error: org.postgresql.util.PSQLException: ERROR: generate_sums(bigint, bigint, bigint) is a procedure Hint: To call a procedure, use CALL.</p>
  <p>After doing some research I think that this is my problem:</p>
  <p><a href="https://github.com/pgjdbc/pgjdbc/issues/1413" rel="nofollow noreferrer">https://github.com/pgjdbc/pgjdbc/issues/1413</a></p>
  <p>However according to this post this issue has been fixed with the Postgres JDBC driver Version higher than 42.2.16:</p>
  <p><a href="https://stackoverflow.com/questions/65696904/postgresql-11-stored-procedure-call-error-to-call-a-procedure-use-call-java">Postgresql 11: Stored Procedure call error - To call a procedure, use CALL, Java</a></p>
  <p>Only difference: they are talking about Spring here, not Quarkus. But looking at the problem this should not make a difference.</p>
  <p>I checked the Maven dependency tree of my Quarkus application and noticed that it uses 42.2.22. So a version which includes this fix.</p>
  <p>However, I still get this error when trying to call the PostgresSQL Stored Procedure from Quarkus.</p>
  <p>The only difference to Davides example is that I don't provide a ResultClass since my procedure is a INSERT SELECT statement which fills a table based on other tables and does not return anything.</p>
  <p>I am using Quarkus 2.0.</p>