Hello Everyone,
I've encountered this while calling a java method from PL/SQL. Here's the full error:
ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.net.SocketPermission www.quandl.com:80 connect,resolve) has not been granted to TRADING_DEV. The PL/SQL to grant this is dbms_java.grant_permission( 'TRADING_DEV', 'SYS:java.net.SocketPermission', 'www.quandl.com:80', 'connect,resolve' )
ORA-06512: at "TRADING_DEV.PKG_MCC", line 370
ORA-06512: at "TRADING_DEV.PKG_MCC", line 663
ORA-06512: at "TRADING_DEV.PKG_MCC", line 684
ORA-06512: at line 7
29532. 00000 - "Java call terminated by uncaught Java exception: %s"
*Cause: A Java exception or error was signaled and could not be
resolved by the Java code.
*Action: Modify Java code, if this behavior is not intended.
Ive followed the suggestions from many sources about running the permissions and I can verify that they are in the dba_java_policy view.
ORA-29532: java call terminated by uncaught java exception: string tips
No matter what I do I still encounter this error.
Any help would be appreciated.