oracle中java类的使用

java类创建:
create or replace and compile java source named test as
public class A
{
  public static String sayHello(String name){
         String ret = dealStr(name);
         return ret;
  }
 
  private static String dealStr(String name){
          return "HELLO "+name+"!";
  }
};

java类的使用:
1.使用function:
create or replace function useClass(s in varchar2) return varchar2 is
LANGUAGE JAVA NAME 'A.sayHello(java.lang.String) return string';

测试:select useClass('liuxx') from dual;

2.使用packages:
create or replace package PUBLIC_UTIL is
  function useClassP(s in varchar2) return varchar2;
end PUBLIC_UTIL;

create or replace package body PUBLIC_UTIL is
  function useClassP(s in varchar2) return varchar2 as
    LANGUAGE JAVA NAME 'A.sayHello(java.lang.String) return string';
end PUBLIC_UTIL;

测试:select PUBLIC_UTIL.useClassP('liuxx') from dual;