Description:
The oracle OS user does not have the appropriate privileges on the OS directory,
or if the path specified in the database does not match to an actual path, the program will hurl the above ORA exceptions.
Cause:
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation
ORA-29532: JAVA CALL terminated BY uncaught JAVA EXCEPTION: JAVA.security.AccessControlException: DIRECTORY permissions restricted.
Solution:
We need to give the proper permission to the folders in OS level to over come the issue.
We can give the three types of permission for dbms_java.grant_permission.
1.READ
2.WRITE
3.EXECUTE
These are the permissions are used to access the directory from database level.
SYNTAX:
Execute the permission:
EXEC dbms_java.grant_permission( ‘SCHEMA NAME’, ‘java.io.FilePermission’, ‘DIRECTORY PATH’,’PERMISSION <READ|WRITE|EXECUTE>’ );
PL/SQL procedure successfully completed.
Example:
EXEC dbms_java.grant_permission(‘XXSC’, ‘java.io.FilePermission’,’/dbtest/warm_dir/test’,’read,write,execute’);
Call the permission:
call dbms_java.grant_permission( ‘SCHEMA NAME’, ‘java.io.FilePermission’, ‘DIRECTORY PATH’,’PERMISSION <READ|WRITE|EXECUTE>’ );
Example:
call dbms_java.grant_permission(‘XXSC’, ‘java.io.FilePermission’,’/dbtest/warm_dir/test’,’read,write,execute’);
call completed
Commit the transaction and retest the issue,
Thank you.
