Environment Details:
OS: Linux 5.8
Database Version: 11.2.0.3.0
Database User: Test
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
OS: Linux 5.8
Database Version: 11.2.0.3.0
Database User: Test
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
No comments:
Post a Comment