Problem in loadjava on unix [message #220835] |
Thu, 22 February 2007 05:44 |
bolyogesh
Messages: 1 Registered: February 2007
|
Junior Member |
|
|
Hi,
We needed to load some java into Oracle database and then we used those loaded classes inside some Oracle function.
We could properly load those java files on oracle server installed on Windows machine with the command:
loadjava -schema pms40 -user pms40/pms40user@
-verbose D:\UUID.java D:\UUIDFactory.java D:\UUIDGenerate.java
but when we are trying to do it on the another db server which is installed on unix machine we are getting the following problmes: I am pasting the errors here:
Can anyone address this? Please can anyone see any clue and suggest something....
pmftestdb% loadjava -schema pms40 -user pms40/pms40@ -verbose /export/home/oracle/UUID.java /export/home/oracle/UUIDFactory.java /export/home/oracle/UUIDGenerate.java
arguments: '-schema' 'pms40' '-user' 'pms40/pms40@' '-verbose' '/export/home/oracle/UUID.java' '/export/home/oracle/UUIDFactory.java' '/export/home/oracle/UUIDGenerate.java'
creating : source PMS40.com/sun/xml/registry/ebxml/util/UUID
loading : source PMS40.com/sun/xml/registry/ebxml/util/UUID
creating : com/sun/xml/registry/ebxml/util/UUID
Error while creating com/sun/xml/registry/ebxml/util/UUID
ORA-06576: not a valid function or procedure name
creating : source PMS40.com/sun/xml/registry/ebxml/util/UUIDFactory
loading : source PMS40.com/sun/xml/registry/ebxml/util/UUIDFactory
creating : com/sun/xml/registry/ebxml/util/UUIDFactory
Error while creating com/sun/xml/registry/ebxml/util/UUIDFactory
ORA-06576: not a valid function or procedure name
creating : source PMS40.UUIDGenerate
loading : source PMS40.UUIDGenerate
creating : UUIDGenerate
Error while creating UUIDGenerate
ORA-06576: not a valid function or procedure name
Error while computing shortname of com/sun/xml/registry/ebxml/util/UUID
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Error while computing shortname of com/sun/xml/registry/ebxml/util/UUIDFactory
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Error while computing shortname of UUIDGenerate
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
The following operations failed
source PMS40.com/sun/xml/registry/ebxml/util/UUID: creation
source PMS40.com/sun/xml/registry/ebxml/util/UUIDFactory: creation
source PMS40.UUIDGenerate: creation
exiting : Failures occurred during processing
pmftestdb% sqlplus
Thanks a mil in advance
|
|
|