Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Any idea about ORA-29541?

Re: Any idea about ORA-29541?

From: JimmyN1 <jimmyn1_at_aol.com>
Date: 17 Sep 2001 16:36:43 GMT
Message-ID: <20010917123643.28937.00000520@mb-mm.aol.com>


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.

  1. 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.
  2. 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)
  3. 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
  4. 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:

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US