PL/SQL 调用 JAVA代码

create or replace and compile java source named "HelloWorld"
as
package com.test;

public class HelloWorld {
　　public static String sayHello(String name){
 　　　　return "hello::"+ name;
　　}
}

create or replace function HelloWorld(p_name in varchar2)
return varchar2
as
　　language java name ‘com.test.HelloWorld.sayHello(java.lang.String) return java.lang.String‘;

--包头
create or replace package PHelloWorld is
  function hello_world(p_name in varchar2) return varchar2;
end PHelloWorld;

--包体
create or replace
package body PHelloWorld is
  function hello_world(p_name in varchar2) return varchar2 is
    language java name ‘com.test.HelloWorld.sayHello(java.lang.String) return java.lang.String‘;
end PHelloWorld;

begin
    htp.print(HelloWorld(‘xx‘));
end;

begin
    htp.print(PHelloWorld.hello_world(‘xx‘));
end;