Java 代码:
public class Test {
public static String test(String test){
return "Hello " + test;
}
}
打个jar包,test.jar。
loadjava -u user/password@sid c:/test.jar
plsql里执行:
create or replace function test(type varchar2) return varchar2 as
LANGUAGE JAVA NAME 'Test.test(java.lang.String) return
java.lang.String';
阅读(523) | 评论(0) | 转发(0) |