Java Stored Procedures in Oracle Lite

Hi all,

I'm working with Oracle Lite 3.5 which should allow Java stored procedures. When I run the supplied example, when it tries to store the procedure:

alter table inventory attach java source "Oracle.POL.INVENTORY" in 'd:\orant\LITE\EXAMPLES\JAVA'
with constructor args(PID,QTY,THRESHOLD);

I receive the errors:

alter table inventory attach java class "Oracle.POL.INVENTORY" *
ERROR at line 1:
OCA-30021: error preparing/executing SQL statement [POL-8010] class with given name not found

I have even tried compiling the package externally and saving the class file:

alter table inventory attach java class "Oracle.POL.INVENTORY" in 'd:\jbuilder2\myclasses\Oracle\POL'
with constructor args(PID,QTY,THRESHOLD);

and receive the same errors.

Any ideas or suggestions?

Howard Neuwirth-Hirsch Received on Fri Oct 02 1998 - 15:46:42 CDT