Search code examples
javaspringspring-dataspring-data-jpa

Calling stored procedure using OUT parameter with Spring Spring JPA 2.*


I am calling a stored procedure using IN parameter - it's working fine.

public interface ABCRepository extends JpaRepository<ABC, Integer> {
    @Query(nativeQuery=true, value="exec p_NextSequence :clazName , 1")
    Integer  callSequenceForClaz(@Param ("clazName")String clazName);
}

Need help how to do it for OUT parameters.


Solution

  • Refer below link for how to call a stored procedure.

    https://dzone.com/articles/calling-stored-procedures-from-spring-data-jpa