Examples of Oracle calling Java methods (all of the code below is written in Sql/plus)

Call the Java program in Oracle, note: The Java method must be of type static if you want to use System.out/err output log in Java.

Need to execute "call Dbms_java.set_output (5000);" In Oracle.
First, Helloword
1 Write Java program, also write in Sql/plus, and execute.

Create or replace and compile Java source named Hello as
public class Hello {
static public string Message (string name) {
Return "Hello," + name;
}
}
/

2 Publishing Java Programs

Create or Replace function hello (name VARCHAR2) return VARCHAR2
As language Java name
' Hello.message (java.lang.String) return java.lang.String ';
/

3 Java programs that use dough

Select Hello (' world! ') from dual;
HELLO (' world! ‘ )
-- -------------
Hello world!

Examples of Oracle calling Java methods (all of the code below is written in Sql/plus)