Error while computing shortname of URLDispatch - ORA-06576: not a valid function or procedure name -

   

The below mentioned URLDispatch.java that runs successfully on the ‘TEST’ server but fails on the actual production server: (details mentioned below)

 

Java Proc - URLDispatch.java

 

Command used - loadjava -u lgsms/lgsms@spx1 -v -resolve URLDispatch.java

 

Error Received :

Error while computing shortname of URLDispatch

ORA-06576: not a valid function or procedure name

ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared

 

STEPS Taken to resolve above issue:

I have also Un-installed the JVM from the production Database using the rmjvm.sql (then bounced database) and then Re-installed using intjvm . sql scripts at the $ORACLE_HOME/javavm/install