ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException

ERROR

ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException

exception in SendMail =ORA-29532: Java call terminated by uncaught Java exception: The PL/SQL to grant this is dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/XXXXXX/sqlcom/out/MISSING_ATTRIBUTE_ITEMS_2111201409:23:51.xls’, ‘read’ ) 

SOLUTION

Login as SYS or SYSTEM user and then assign the required permission

$sqlplus / as sysdba

SQL>EXEC DBMS_JAVA.GRANT_PERMISSION(‘APPS’,’SYS:java.io.File/ Permission’,’/XXXXXX/sqlcom/out/*’,’read,write’);

PL/SQL procedure successfully completed.

SQL>commit;

Commit complete.