Java and JavaScript in the Database

Hi

I'm simply trying to publish a test pl/sql package using JPublisher from a client command line without success. I've defined my Classpath as follows:

CLASSPATH=.;%ORACLE_HOME%\LIB\xmlparserv2.jar;
%ORACLE_HOME%\jdbc\lib\ojdbc14.jar;
%ORACLE_HOME%\jdbc\lib\orai18n.jar;
%ORACLE_HOME%\sqlj\lib\translator.jar;
%ORACLE_HOME%\sqlj\runtime12.jar;
%ORACLE_HOME%\sqlj\runtime12ee.jar;

Note that I have put the first entry for the xmlparserv2.jar here in response to the resulting error I get after running the following jpub invocation:

C:\10GIDS\BIN>jpub -u XMLDBMASTER/password -sql=JOHN_TEST(testReturnXML) -url=jdbc:oracle:oci:@stir-db-orc01:1521/C02D

The response is:

NOTE: xmlparserv2.jar missing in CLASSPATH, SQL-Java type mapping for SYS.XMLTYPE skipped.
XMLDBMASTER.JOHN_TEST
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jpub/reflect/Client
at oracle.jpub.javarefl.JavaMethod.<init>(JavaMethod.java:94)
at oracle.jpub.javarefl.SqlJavaMethod.<init>(SqlJavaMethod.java:40)
at oracle.jpub.publish.AbstractMethodWriter.userMethodDeclaration(Abstra
ctMethodWriter.java:373)
at oracle.jpub.publish.AbstractMethodWriter.userMethodDeclaration(Abstra
ctMethodWriter.java:222)
at oracle.jpub.publish.AbstractMethodWriter.methodDeclarations(AbstractM
ethodWriter.java:108)
at oracle.jpub.publish.AbstractMethodWriter.userMethodDeclarations(Abstr
actMethodWriter.java:77)
at oracle.jpub.publish.SqlPackageWriter.<init>(SqlPackageWriter.java:52)

at oracle.jpub.publish.JavaPublisher.publish(JavaPublisher.java:267)
at oracle.jpub.Doit.mainSql(Doit.java:353)
at oracle.jpub.Doit.main(Doit.java:126)
at oracle.jpub.Doit.main(Doit.java:101)
at oracle.jpub.Doit.main(Doit.java:57)
at oracle.jpub.publish.Main.main(Main.java:9)
at oracle.jpub.Main.main(Main.java:6)

I'm no java programmer and wondered what the error message really points to: is it directly related to the fact that the Function in the package returns an XMLTYPE and it can't see the xmlparserv2.jar (which I plainly have in the CLASSPATH) i.e.can't deal with XMLTYPES?

I've spent a lot of time on this and really need to get things moving, can anyone help?