Hi there, I got this from metalink for you:
Doc ID: Note:135347.1
Subject: ORA-29541 and Java Stored Procedure
Type: PROBLEM
Status: REVIEW_READY
Content Type: TEXT/PLAIN
Creation Date: 09-FEB-2001
Last Revision Date: 09-FEB-2001
Problem Description
You have loaded Java classes into the database and get this on execution:
ORA-29541: class aSuspicousClass could not be resolved
where aSuspicousClass is the name of the class supposed to be executed.
Solution Description
Either the JVM is incomplete, the specific class is not there, a dependency
of the is not there, or the class is not valid.
- Is JVM installed ?
SQL> select count(*) from dba_objects where object_type like '%JAVA%';
You should get 8000+ classes.
-- If not, run the $ORACLE_HOME/javavm/install/initjvm.sql script.
- Is the class present ?
SQL> select * from all_objects where object_name like
dbms_java.longname('%aSuspiciousClass%');
-- If not, run loadjava. For a single class, that looks like:
- OS% loadjava -u scott/tiger -resolve aSuspiciousClass.class (or .java)
- (if loaded as a ZIP file, try re-loading but as a JAR file)
- Is the class VALID ?
look at the output from the above query for STATUS ... is it VALID ?
-- If not, try to compile the code outside Oracle.
- OS% javac aSuspiciousClass.java
- Are there dependent classes ?
Look at the source, find dependent classes at the failure class.
Make sure all dependent classes are in using the SQL selects above.
Explanation
Either the JVM is incomplete, the specific class is not there, a dependency
is not there, or the class is not valid.
In general, try to:
- load classes (*.class) rather than source (*.java) into the database
- be sure your classes compile cleanly - compile outside the database first
- load the classes with the '-resolve' option to catch errors early
References
Note:1073285.6 ORA-29541 When Executing Java Stored Procedure
Note:108246.1 Incomplete loading of zip file w/ loadjava
Note.71556.1 OERR ORA-29541 class %s.%s could not be resolved:
.
Received on Mon Sep 17 2001 - 11:36:43 CDT