create or replace and compile java source named "HelloWorld"

as

package com.test;

public class HelloWorld {

public static String sayHello(String name){

 System.out.println("hello::"+ 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;