Hi,
I need to read data from a file, so I create a Java Stored Procedure, but when I call the procedure this error is returned:
ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.io.FilePermission /PublicFiles/tete.dxf read) has not been granted to TESTDXF. The PL/SQL to grant this is dbms_java.grant_permission('TESTDXF', 'SYS:java.io.FilePermission', '/PublicFiles/tete.dxf', 'read' )
I tried to set the permission using the dbms_java package but I couldn't find the grant_permission procedure, and one more thing, how to set read/write/delete permission to a directory, and not just to a single file?
I'm using Oracle 9i Release 2.
Thanks.
I need to read data from a file, so I create a Java Stored Procedure, but when I call the procedure this error is returned:
ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.io.FilePermission /PublicFiles/tete.dxf read) has not been granted to TESTDXF. The PL/SQL to grant this is dbms_java.grant_permission('TESTDXF', 'SYS:java.io.FilePermission', '/PublicFiles/tete.dxf', 'read' )
I tried to set the permission using the dbms_java package but I couldn't find the grant_permission procedure, and one more thing, how to set read/write/delete permission to a directory, and not just to a single file?
I'm using Oracle 9i Release 2.
Thanks.