LOAD JAVA FILES TO THE DB USER

[oracle@localhost jlib]$ loadjava -user HR mail.jar


Password:
********                                                                                                                                                              
[oracle@localhost jlib]$ !sq
sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 28 14:35:20 2016


Copyright (c) 1982, 2014, Oracle.  All rights reserved.




Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options






SQL>  begin dbms_java.grant_permission( ‘HR’, ‘SYS:java.net.SocketPermission’,’localhost:PORT’,’connect,resolve’);end;
  2  /


PL/SQL procedure successfully completed.


SQL> BEGIN dbms_java.grant_permission( ‘HR’,’SYS:java.net.SocketPermission’, ‘zpop.hybridzimbra.com’, ‘resolve’ );end;
  2  /


PL/SQL procedure successfully completed.

  • May 31, 2016 | 26 views