Java Stored Procedure

From: Samuel Wikberger <ia97swi_at_student.hk-r.se>
Date: 2000/03/10
Message-ID: <rd4y4.16$n4.7678_at_newnews.hk-r.se>#1/1

I have created a javafile that looks like:

public class Test
{

    public static void updateRow(String name)     {

        int zip;


        #sql { SELECT zipcode INTO :zip FROM Person WHERE name= : name};


        zip++;


        #sql { UPDATE Person SET zipcode = :zip WHERE name= : name };

    }
}

When I try to load this into the DB with the LOADJAVA command I get the following error message:

E:\person>loadjava -user scott/tiger_at_samuel:1521:egert 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(SourceFileRead er.java:52)

        at
oracle.aurora.server.tools.SourceFileReader.getFirstName(SourceFileRe ader.java:61)

        at
oracle.aurora.server.tools.LoadJava.processLoadAndCreate(LoadJava.jav a: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) loadjava: 1 errors

What is wrong?

/Samuel Received on Fri Mar 10 2000 - 00:00:00 CET