Tuesday, 24 November 2009

ORA-29541: class could not be resolved

Load/Drop java

dropjava -verbose -user test/test@test_1  test.jar
loadjava -resolve -verbose -grant public -user test/test@test_1  test.jar


loadjava -verbose -user test/test@test_1 JavaTest.class ??
loadjava -verbose -user test/test@test_1 c:\JavaTest.java


CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "JavaTest" AS
   public class JavaTest {
   public static String sayHello (String  name) {
   return "Hello, " + name+ "!";
     }
  };



check the status of object

select * from all_objects where object_type like '%JAVA%';

1 comment:

Rajesh said...

Thanx for the resolutions.