在Oracle中设置Java存储过程的类路径

public class MyJavaClass {
    public static void myMethod() {
        System.out.println("Hello, Oracle!");
    }
}

javac MyJavaClass.java

jar cvf my_java_class.jar MyJavaClass.class

CREATE JAVA SOURCE NAMED "MyJavaClass" AS
  'jar:file:/path/to/my_java_class.jar!/MyJavaClass.class';

CREATE JAVA CLASS "MyJavaClass" AS
  'MyJavaClass';

CREATE OR REPLACE FUNCTION my_java_function
  RETURN VARCHAR2
  AS LANGUAGE JAVA
  NAME 'MyJavaClass.myMethod() return java.lang.String';

SELECT my_java_function() FROM DUAL;

Hello, Oracle!