Home » Developer & Programmer » JDeveloper, Java & XML » Problem in loadjava on unix
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

Previous Topic: JAVA and PL/SQL
Next Topic: typing a java class that return array , and i control it in an oracle procedure ?????
Goto Forum:
  


Current Time: Thu Apr 25 04:48:48 CDT 2024