Re: installing java on RDBMS execute fails with ORA-29532
Date: Thu, 28 Feb 2008 01:38:00 -0800 (PST)
Message-ID: <92aaeca5-4de0-4571-9d1f-b8d3225b8f5a@d4g2000prg.googlegroups.com>
On Feb 28, 4:12 am, Maria <evora..._at_yahoo.ca> wrote:
> SQL> execute
> dbms_java.grant_permission('soasystest_win1','SYS:java.util.Propert
> yPermission','http.proxySet','write');
>
> BEGIN dbms_java.grant_permission('test1','SYS:java.util.PropertyPermis
> sion','http.proxySet','write'); END;
>
> *
> ERROR at line 1:
> ORA-29532: Java call terminated by uncaught Java exception:
> oracle.aurora.vm.IdNotFoundException: -1 is not the number of a user
> or role
> ORA-06512: at "SYS.DBMS_JAVA", line 313
> ORA-06512: at line 1
User names in dbms_java.grant_permission() calls are CaSe-SeNsItIvE. That is, usually all-uppercase. The issue is clearly visible from the error thrown: the user name was not resolved to an ID.
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Thu Feb 28 2008 - 03:38:00 CST