calling external procedures in windows 7 giving exception

calling external procedures in windows 7 giving exception

Postby peddiraju » Wed 10 Nov 2010 05:43

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.
peddiraju
 
Posts: 6
Joined: Fri 29 Oct 2010 05:32

Postby Shalex » Thu 11 Nov 2010 09:16

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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby peddiraju » Tue 16 Nov 2010 11:26

Hi Thanks for the idea.I have used dbms_java.grant_permission.It is working now.
peddiraju
 
Posts: 6
Joined: Fri 29 Oct 2010 05:32


Return to dotConnect for Oracle