Oracle9i 调用java代码

1.新建一个java source:

create or replace and compile java source named Hello as


public class Hello {

  public static String sayHello(String name){
    return "hello,"+name;
  }

}

2.创建调用的函数:

create or replace function execHello(cmd varchar2) return varchar2
  as language java
  name 'Hello.sayHello(java.lang.String) return varchar2';

3.调用:

select execHello('kusix') from MDSYS.CS_SRS where rownum<2