Friday, September 27, 2013

Oracle 11g | Invalid Java Class Objects

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

No comments:

Post a Comment