oracle中java类的使用

 方式一：编写一个简单的java类vi OracleJavaDemo.javapublic class OracleJavaDemo {     public static String processData(String input) {         return "Processed: " + input;     } }编译javac OracleJavaDemo.java生成OracleJavaDemo.class导入java类到oracle数据库库 loadjava -user scott/passwd@192.168.238.150/orcl OracleJavaDemo.class导入后通过PL/SQL Developer可以看到java classes下会有java类名称存在 创建函数调用java类 CREATE OR REPLACE FUNCTION call_java_func (p_in IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA  NAME 'OracleJavaDemo.processData(java.lang.String) return java.lang.String';调用函数查询 SELECT call_java_func('Testabc') FROM dual; 方式二：可以通过创建java source做为java代码使用 CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "OracleJD" AS public class OracleJD {     public static String processData(String input) {         return "Processed: " + input;     } } /创建调用的存储过程CREATE OR REPLACE FUNCTION call_OracleJD (c1 VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'OracleJD.processData(java.lang.String) return java.lang.String';通过查询SELECT call_OracleJD('Testabc') FROM dual;