Oracle 调用Java方法
1.编写java类并编译（oracle调用的java方法必须是static）package com.demo.db.oracle;public class TestOracle { publicstatic 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;
页:
[1]