How to call sample helloword func using a java code

Question

I am new to Functions as a service. I have done all the relavant setup and get below output for command command : fn invoke helloworld-app helloworld-func Output: Hello, world!

Now I need to invoke the helloworld-func using java client code which can run on any location. Is it possible ? If yes how ?

What's the role of Oracle in this scenario? – sticky bit Mar 09 '20 at 11:41 — sticky bit, Mar 09 '20 at 11:41

score 1 · Answer 1 · answered Mar 09 '20 at 12:13

In Oracle RDBMS you can compile a java source:

CREATE AND COMPILE JAVA SOURCE NAMED helloworld_app_source AS
public class helloworld_app {
  public static String helloworld_func()
  {
    return "Hello, world!";
  }
}

Then you can wrap it in an Oracle function:

CREATE FUNCTION helloworld_func RETURN VARCHAR2
AS LANGUAGE JAVA NAME 'helloworld_app.helloworld_func() return java.lang.String';
/

Then you can just call it in an normal SQL statement (as per any other function):

SELECT helloworld_func() FROM DUAL;

The Java function will run on the server but the query can be invoked from any SQL client connected to the server and will return the output to that client.

How to call sample helloword func using a java code

1 Answers1

Linked