Oracle stored procudures

Hello,

 we have the following problem:
[Quoted] We want to write a java stored procedure with Oracle 8i. Here are the SQL statements we use for this:

     create or replace directory b_dir
     as '/test';

     create or replace java class
     using BFILE(b_dir, Hello.class');

     create or replace procedure EXECUTE
     as language java name 'Hello.execute()';

 Now, if we want to call the procedure with:
     call EXECUTE();
we get the following error message:
     call EXECUTE()
           *
     ERROR at line 1:
     ORA-29541: class System.Hello could not be resolved

 Have you any idea what we made wrong. Where´s is the error in our commands ???

 Thanks for your help. Received on Thu Jan 11 2001 - 09:41:51 CET