Oracle 调用Java方法

1.编写java类并编译（oracle调用的java方法必须是static）

 

package com.demo.db.oracle;



public class TestOracle {


    public  static String sayHello(){
        return "Hello Java product";
    }

}

 

2.读取java class到oracle中

 

   loadjava -r -f -v d:/Test/com/demo/db/oracle.TestOracle.class

 

3.编写oracle函数

 

   create or replace function helloworld return varchar2 as language java name 'com.demo.db.oracle.TestOracle.sayHello() return java.lang.String';

 

4.执行

 

SQL> VARIABLE myString VARCHAR2(20);
SQL> CALL helloworld () INTO :myString;
Call completed.
SQL> PRINT myString;