calling external procedures in windows 7 giving exception

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
peddiraju
Posts: 6
Joined: Fri 29 Oct 2010 05:32

calling external procedures in windows 7 giving exception

Post by 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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by 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.

peddiraju
Posts: 6
Joined: Fri 29 Oct 2010 05:32

Post by peddiraju » Tue 16 Nov 2010 11:26

Hi Thanks for the idea.I have used dbms_java.grant_permission.It is working now.

Post Reply