Oracle中施行java代码

Oracle中执行java代码

1.在ORACLE数据库中创建功能类(实现签名):

create or replace and compile java source named TestName aspublic class SingleName{public static String testStr="Test Str";public static void entry(){}public static String getMsg(String test){return test + testStr;}}

?2.利用功能类方法创建数据库函数:

create or replace function getName(l_str varchar2) return string as language java name'SingleName.getMsg(java.lang.String) return java.lang.String';

select getName('This is ') from dual

?