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);
}

JavaScript
​x
 
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.

Answer

Refer below link for how to call a stored procedure.

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

Advertisement

Answer