Help with Java Stored Procedures in Oracle

Hopefully someone has run across this before. I have been beating my head on this for several days.

The client side is JBuilder Enterprise Version 3.00 on a Pentium III running NT 4.0.
The server side is Oracle 8i Version 8.1.5 on a Data General Aviion running DG/UX Release R4.20MU05.

I have written a Java Stored Procedure and I can execute it without any trouble from sqlplus.
I can also execute PL/SQL Stored Procedures without any trouble from the client. However if I try to execute the Java Stored Procedure from the client either directly using a CallableStatement object, or indirectly (i.e. Database Trigger or from a PL/SQL Stored Procedure) I get the following error:

SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException ORA-06512: at "ALPHA1V1.EXEC_COMPILER", line 0

where EXEC_COMPILER is the call spec that publishes the Java Stored Procedure.

Again, I have not trouble calling it from the sqlplus command prompt either directly or indirectly, but I get that error no matter what I try when calling it from the client. I would greatly appreciate any input.

Thank you,

Gary Fowler
3M Health Information Systems
grfowler_at_mmm.com Received on Tue Dec 28 1999 - 13:32:06 CST