I am desperately trying to learn how to use java stored procedures and I have been unable to get ahead so far.
One thing I managed to do is get the JVM installed, activated. I also confirmed that on of java objects were large enough using the following query.
SELECT COUNT(*) AS "TOTAL_JAVA_OBJECTS" FROM DBA_OBJECTS WHERE OBJECT_TYPE LIKE 'JAVA%';
This gives me 6786 rows.
Also there are no invalid java objects.
SELECT COUNT(*) AS "TOTAL_INVALID_JAVA_OBJECTS" FROM DBA_OBJECTS WHERE OBJECT_TYPE LIKE 'JAVA%' AND STATUS = 'INVALID';
NOW when I use command line loadjava (from unix bash), it hangs on me and JRE (in unix TOP) shows 70-90% CPU usage.
loadjava -u user/password -resolve Dba.class
I also tried loading the same from TOAD, and get the below attached errors.
This is urgent, as I have been struggling for more than a week now to get it figured out.
I would appreciate help on this.
Thanx and Regards
18:29:36 Info: java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl, 18:29:36 Info: at oracle.aurora.server.tools.loadjava.SourceFileRead er.getScanner(SourceFileReader.java:52), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.SourceFileRead er.getFirstName(SourceFileReader.java:61), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.LoadJava.noteS ource(LoadJava.java:2427), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.LoadJava.proce ssLoadAndCreate(LoadJava.java:1587), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.LoadJava.proce ssLoadAndCreate(LoadJava.java:1513), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.LoadJava.proce ss(LoadJava.java:1422), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.LoadJavaMain.r un(LoadJavaMain.java:299), 18:29:36 Info: at oracle.aurora.server.tools.loadjava.LoadJavaMain.m ain(LoadJavaMain.java:58), 18:29:36 Info: resolver :, 18:29:36 Info: loadjava: 1 errors, 18:29:36 Info: Loaded successfully, 18:29:36 Info: Java Load Completed: Files that have already been loaded that have not changed have not been loaded again.
Last edited by aruneeshsalhotr; 07-30-03 at 20:16.