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
– sticky bit

2020-03-09 11:41:59 +00:00
Commented Mar 9, 2020 at 11:41 — sticky bit
– sticky bit, Commented Mar 9, 2020 at 11:41

MT0 · Accepted Answer · 2020-03-09 12:13:16Z

1

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.

answered Mar 9, 2020 at 12:13

MT0

173k12 gold badges70 silver badges136 bronze badges

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

Collectives™ on Stack Overflow

How to call sample helloword func using a java code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related