Cannot grant permissions with dbms_java

Cannot grant permissions with dbms_java

Hello,
I am having problems with a stored procedure (PL/SQL) which calls a java class stored externally (mapped to DB using CREATE DIRECTORY, CREATE JAVA CLASS).
The java class calls a .bat file.
Calling the stored procedure gives

SQL> exec proc_batch();
BEGIN proc_batch(); END;

*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.io.FilePermission <<ALL
FILES>> execute) has not been granted by dbms_java.grant_permission to SchemaProtectionDomain(TEST|PolicyTableProxy(TEST)) ORA-06512: at "TEST.PROC_BATCH", line 0 ORA-06512: at line 1

Using dbms_java does not solve this.
exec dbms_java.grant_permission('TEST',
'java.io.FilePermission',
'<<ALL_FILES>>',
'read,execute');

User TEST has DBA rights (inc. JAVA_ADMIN)

Can anyone help? Received on Sat Jan 25 2003 - 14:54:46 CST