Re: Unable to load Java procedure in Oracle 8i

Hi!

I believe the loadjava utility is intended to load classes and not source.

You procedure specification probably has an error, try the following from SQL*Plus:

alter procedure fib compile;
show errors

Hope this helps

Michel

smanux_at_dream.club-internet.fr wrote:
>
> 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 - 08:11:56 CDT