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