DBMS_JAVA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DBMS_JAVA

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Posts
    27

    Thumbs up

    DBA's

    SQL > exec dbms_java.grant_permission('SCOTT',
    'java.util.PropertyPermission',
    '*',
    'read,write');

    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:
    java.lang.ClassNotFoundException: java/util/propertypermission
    ORA-06512: at "SYS.DBMS_JAVA", line 0
    ORA-06512: at line 1


    any suggestions ???

    Sunny

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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...

  3. #3
    Join Date
    Mar 2001
    Posts
    314
    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%';

    -amar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width