Oracle PL/SQL Tutorial/System Packages/dbms java
dbms_java.grant_permission
SQL> begin
2 dbms_java.grant_permission(
3 grantee => "YourName",
4 permission_type => "java.net.SocketPermission",
5 permission_name => "*",
6 permission_action => "connect,resolve" );
7 end;
8 /
dbms_java.grant_permission(
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier "DBMS_JAVA.GRANT_PERMISSION" must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
SQL>
SQL>