oracle 91 调用java代码

1.coder

create or replace and compile java source named Hello as   
  
  
public class Hello {   
     
  public static String sayHello(String name){   
    return "hello,"+name;   
  }   
  
}  

2.coder

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

3.coder

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

评论

1 楼 melin 2009-02-25  

你好，按照你的实例运行。出现下面错误,还请帮助

ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler