Page 1 of 1

calling external procedures in windows 7 giving exception

Posted: Wed 10 Nov 2010 05:43
by peddiraju
Hi , When we are trying to access java external procedure from Oracle 11g in windows 7. it is giving the following exception.
Devart.Data.Oracle.OracleException: ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException.
Please throw some ideas.

Posted: Thu 11 Nov 2010 09:16
by Shalex
Please try executing the same external procedure with the same Oracle's user in different tool (e.g., SQL Plus). Maybe your Oracle's user doesn't have enough privileges. Also try running your program with the Run as Administrator option.

Posted: Tue 16 Nov 2010 11:26
by peddiraju
Hi Thanks for the idea.I have used dbms_java.grant_permission.It is working now.