加载JAVA包
loadjava ‐u 用户名/密码 ‐v ‐resolve jar包.java**
删除JAVA包:
dropjava ‐u 用户名/密码 ‐v jar包.java
java 引用报错需要加权限 :
SQL>GRANT EXECUTE ON dbms_crypto TO 用户名;
SQL>GRANT EXECUTE ON dbms_java TO 用户名;
SQL>此处省略创建sm4_encrypt函数
SQL> select sm4_encrypt('1111', '1111') from dual;
ERROR at line 1:
ORA‐29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException
SQL> conn / as sysdba
Connected.
SQL> exec dbms_java.grant_permission( '用户名', 'SYS:java.lang.RuntimePermission', 'accessClassInPackage.sun.misc', '' )
PL/SQL procedure successfully completed.