SQL > exec dbms_java.grant_permission('SCOTT',
When I issued following command from sys user I got follwing error :
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
ORA-06512: at "SYS.DBMS_JAVA", line 0
ORA-06512: at line 1
any suggestions ???
make sure you have the appropriate database roles granted to execute java. Not sure exactly which one it is, but there are several roles that start with the word JAVA. It is one (or more) of these...
Check to see if you have the 'java/util/PropertyPermission' status as VALID or if you have it at all. All query like the following will show you what you have:
select * from dba_objects where upper(object_name) like '%PROPERTYPERMISSION%';