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;