研究了一下用plsql创建java类并调用，结果理想。

1、创建java类

--创建java类
--DROP JAVA SOURCE  "Hello"
create or replace and compile
    java source named "Hello"
    as
    import java.lang.*;
    public class Hello
    {
        public static String say(String args)
        {
            return args;
        }
    }
/
--Java created.


2、创建function调用java类

--创建function
CREATE OR REPLACE FUNCTION Hello(message IN VARCHAR2) RETURN VARCHAR2 AS
    LANGUAGE JAVA NAME 'Hello.say(java.lang.String) return String';
/
--Function created.


3、测试function

--测试function
BEGIN
    Dbms_Output.Put_Line(Hello('test ok!'));
EXCEPTION
    WHEN OTHERS THEN
        NULL;
END;
/
       
--test ok!
       
--PL/SQL procedure successfully completed