postgresql « Stored Procedure « JPA Q&A





1. JPA & PostgreSQL: How do I call a stored procedure with void return type?    stackoverflow.com

I'm trying to call a PL/pgSQL function that executes an update (language sql, returns void). I'm getting this exception: Internal Exception: org.postgresql.util.PSQLException: A result was returned when none was expected. persistence.xml:

<named-native-query name="Clinic.deactivateByNotFoundInIncomingClinic">
  ...