title: Spring Data JPA calling Oracle Function
body: <p>I am running an simple application that uses Spring Boot + Spring Data JPA for persistence.</p>
  
  <p>Below is a sample Oracle function I would like to have the value returned at the Service implementation class.</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE PKG_TEST AS 
    FUNCTION HELLO_WORLD(TEXT VARCHAR2) RETURN VARCHAR2;
  END PKG_TEST;
  
  CREATE OR REPLACE PACKAGE BODY PKG_TEST AS 
    FUNCTION HELLO_WORLD(TEXT VARCHAR2) RETURN VARCHAR2 IS
    BEGIN
      RETURN 'HELLO WORLD ' || TEXT;
    END;
  END PKG_TEST;
  </code></pre>
  
  <p>Doing this with no framework would be simple, but the project is built into Spring Boot JPA, so it's better to use it.</p>
  
  <p>I need a reference guide link or simple base structure to follow. 
  I searched all over SO and Spring Data JPA reference and all examples I found are for CRUD and Stored Procedures, nothing for Functions. </p>
  
  <p>I tried to use the Stored procedure example modified for function but didn't work.</p>