Oracle 9 i呼び出し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