How Do I Call a User Defined Sql Function from Springboot?
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...
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.
3 Answers
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
The solution:
@Query(nativeQuery = true, value = "SELECT package.function("variables: value") FROM dual")
float getFuction(@Param("value") String value);
Nice overview about this topic can be found here:
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
