Unable to load Java procedure in Oracle 8i

From: <smanux_at_dream.club-internet.fr>
Date: Fri, 13 Aug 1999 14:35:13 +0200
Message-ID: <37B41101.B64D3EBA@dream.club-internet.fr>

Hello,

I'm facing a weird problem with Java stored procedures in Oracle 8i. Each time i try to use the loadjava utility, i get this error message :

C:\>loadjava -u scott/tiger_at_myPC:1521:orcl -v -r -t test.java

internal error: unanticipated exception: java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl
java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl

   at oracle.aurora.server.tools.SourceFileReader.getScanner

(SourceFileReader.java:52)

   at oracle.aurora.server.tools.SourceFileReader.getFirstName

(SourceFileReader.java:61)

   at oracle.aurora.server.tools.LoadJava.processLoadAndCreate

(LoadJava.java:1094)

   at oracle.aurora.server.tools.LoadJava.process(LoadJava.java:1021)
   at oracle.aurora.server.tools.LoadJavaMain.run(LoadJavaMain.java:193)
   at oracle.aurora.server.tools.LoadJavaMain.main(LoadJavaMain.java:49)

resolver :
loadjava: 1 err

Anyway, if i try to load the .class instead of the .java, loadjava works C:\>loadjava -u scott/tiger_at_myPC:1521:orcl -v -r -t test.class

But then i'm unable to publish my procedure in Oracle (I copy/past the Fibonnaci example from Oracle documentation, and Oracle says that the object 'fib' is invalid when i type the 'desc fib' command.)

Has anyone an idea about this ?

Thanks

Emmanuel BOURG Received on Fri Aug 13 1999 - 07:35:13 CDT