How do I call a user defined sql function from springboot?

Question

I'm trying to call a user defined function from PLSQL database, it takes several variables and return a single float.

I've tried code like this:

@Query(nativeQuery = true, value = "SELECT package.function("variables: 
value")
float getFuction(@Param("value") String value);

This shows an error saying "FROM keyword was not found where expected.

Maybe you need add ` from dual` Check this stackoverflow.com/questions/45867348/… — lczapski
– lczapski, Commented Oct 31, 2019 at 12:29

lczapski · Accepted Answer · 2019-10-31 12:38:31Z

3

I think that it should be like that (i do not have chance to check):

@Query(nativeQuery = true, value = "SELECT package.function(:value) FROM dual")
float getFuction(@Param("value") String value);

It is based on this answer

answered Oct 31, 2019 at 12:38

lczapski

4,1603 gold badges18 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vladas Maier · Accepted Answer · 2019-10-31 12:41:17Z

0

The solution:

@Query(nativeQuery = true, value = "SELECT package.function("variables: value") FROM dual")
float getFuction(@Param("value") String value);

Vladas Maier

2,1822 gold badges25 silver badges37 bronze badges

answered Oct 31, 2019 at 12:34

Raket Makhim

1571 gold badge2 silver badges9 bronze badges