Issue: Java Class/Classes became INVALID after the upgrade of the database
Solution: First Compile and then resolve the Java Classes by using the below command.
ALTER JAVA SOURCE "OWNER"."OBJECT_NAME" COMPILE;
ALTER JAVA CLASS "OWNER"."OBJECT_NAME" RESOLVE;
Example:
SQL> select owner , object_name, object_type from dba_objects where status='INVALID';
OWNER OBJECT_NAME OBJECT_TYPE ----------- ----------------------- ----------- TEST TestStringTokenizer JAVA CLASS TEST TestStringTokenizer JAVA SOURCE
SQL> ALTER JAVA SOURCE "TEST"."TestStringTokenizer" COMPILE; Java altered.
SQL> ALTER JAVA CLASS "TEST"."TestStringTokenizer" RESOLVE; Java altered.
SQL> select owner , object_name, object_type from dba_objects where status='INVALID'; no rows selected
Advertisements