Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose
Enables and disable the grants on Java classes to PUBLIC as part of the introduction of a new ORACLE_JAVA_DEV role introduced in version 19c.
This package is not installed by default using DBCA.
AUTHID
DEFINER
Dependencies
DBA_DEPENDENCIES
DBMS_OUTPUT
DBMS_UTILITY
DBA_OBJECTS
DBMS_REGISTRY
PLITBLM
DBA_TAB_PRIVS
DBMS_SESSION
V$PARAMETER
DBMS_ASSERT
DBMS_STANDARD
Documented
No
Exceptions
Error Code
Reason
ORA-1921
Role exists
ORA-2264
constraint_exists
ORA-20031
Java Development Disabled
ORA-20032
ora_script_set,
ORA-20033
'Can not ' || action || ' when JAVAVM is not loaded'
First Available
19c
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/dbmsjdev.sql
SQL> @?/rdbms/admin/dbmsjdev.sql
Session altered.
PL/SQL procedure successfully completed.
Trigger created.
View created.
Synonym created.
Grant succeeded.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
SP2-0810: Package Body created with compilation warnings
Session altered.
SQL> sho err
Errors for PACKAGE BODY SYS.DBMS_JAVA_DEV:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8/12 PLW-06010: keyword "VALUE" used as a defined name
19/10 PLW-06009: procedure "VERIFY_ORACLE_SCRIPT_PARAM" OTHERS handler
does not end in RAISE
36/10 PLW-06009: procedure "VERIFY_JAVAVM_LOADED" OTHERS handler does not end in RAISE