您还可以直接将Java源代码编译并保存在数据库中,例如存储过程:
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Hello" ASpublic class Hello{ public static String world() { return "Hello world"; }};/> Java created调用此函数很简单,不需要其他设置:
CREATE OR REPLACEFUNCTION helloworld RETURN VARCHAR2 ASLANGUAGE JAVA NAME 'Hello.world () return java.lang.String';/DECLARE my_string VARCHAr2(400 CHAR);BEGIN my_string := helloworld(); dbms_output.put_line('The value of the string is ' || my_string);END;/> The value of the string is Hello world> PL/SQL procedure successfully completed


