Thread: !
-
!
Hello,
Thanks in advance for helping. Here is the problem...
I'm testing a Java proc that I will be calling in a trigger. This proc works when run from a command line outside of oracle.
In the PBRELIN schema I run:
exec :x := pbrelin.createRemedyTicket('WE','S0400', '111', 'WE', 'A0400', '112', 'Bob Jones', 'Boss');
I get...
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.security.AccessControlException: the Permission
(java.util.PropertyPermission java.lib.path write) has not been granted to PBRELIN. The PL/SQL to grant this is dbms_java.grant_permission( 'PBRELIN',
'SYS:java.util.PropertyPermission', 'java.lib.path', 'write' )
ORA-06512: at "PBRELIN.CREATEREMEDYTICKET", line 0
ORA-06512: at line 1
So in the PBRELIN schema I run
exec dbms_java.grant_permission('PBRELIN', 'SYS:java.util.PropertyPermission', 'java.lib.path', 'write' );
PL/SQL procedure successfully completed.
I run the createRemedyTicket java proc again and I get the same error.
So, I connect to SYS/xxxx as sysdba and run
exec dbms_java.grant_permission('SYS', 'SYS:java.lang.RuntimePermission', 'loadLibrary.arjni60', 'read ,write, execute, delete' );
AND
call dbms_java.grant_policy_permission('PBRELIN','SYS','java.io.FilePermission','*');
connect back to PBRELIN
I run the createRemedyTicket java proc again and I get the same error.
I've checked my class paths, they seem ok.
Any ideas what I might be doing wrong?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|