Re: Unable to load Java procedure in Oracle 8i

I assume you are using NT. According to Oracle, here's the solution:

Update your CLASSPATH via your Environment Panel (START->SETTINGS->CONTROL PANEL->SYSTEM->ENVIRONMENT). The path you need to add is: ORACLE_HOME\SQLJ\LIB\TRANSLATOR.ZIP.

--Jonathan

In article <37B41101.B64D3EBA_at_dream.club-internet.fr>,   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
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 17 1999 - 15:30:22 CDT