Created
October 4, 2018 15:28
-
-
Save sangimed/92543f4e095b6861ce3b200e9b2eb19d to your computer and use it in GitHub Desktop.
Call a plsql procedure with JPA in Spring
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package mypackage; | |
import javax.persistence.EntityManager; | |
import javax.persistence.ParameterMode; | |
import javax.persistence.PersistenceContext; | |
import javax.persistence.StoredProcedureQuery; | |
import org.springframework.stereotype.Component; | |
@Component | |
public class ProcedureQueries { | |
@PersistenceContext | |
private EntityManager entityManager; | |
public String myfunc(final String param) { | |
StoredProcedureQuery query = entityManager.createStoredProcedureQuery("plsql_procedure_name") | |
.registerStoredProcedureParameter("pram", String.class, ParameterMode.IN) | |
.registerStoredProcedureParameter("result", String.class, ParameterMode.OUT) | |
.setParameter("pram", param); | |
query.execute(); | |
return (String) query.getOutputParameterValue("result"); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment