................[@more@]

项目中，要用到一个上传文档的功能，用一个orcale的的存储过程去调用 java 类，再由java类调用系统指指令，但始终报一个这样的错误 dbms_java.grant_Permissio('SCOTT','java.io.FilePermission','/tmp/inbound/**','read,write,execute,delete');
ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.vm.IdNotFoundException: my_user is not a user or role，ORA-29532: Java call terminated by uncaught Java exception:
java.lang.SecurityException: policy table update SYS:java.io.FilePermission,
'/tmp/inbound/*

解决方法:

call dbms_java.grant_permission( 'TEST', 'SYS:java.io.FilePermission', '/tmp/inbound/*', 'read, write' );

ITPub博客

dbms_java.grant_Permissio 使用/ORA-29532

最新文章