Oracle Java External Procedure Problem - ORA-29531: no method sayIt in class Hello

Oracle Java External Procedure Problem - ORA-29531: no method sayIt in class Hello

I used the following mechanism to test using a simple java class as an Oracle external procedure
Class:
public class Hello {
      public static String sayIt (String toWhom){
            return "Hello, " + toWhom + "!";
      }
}
...compile Hello.java, ftp to /app/zora03/releaseTLM2.0.0.2.8/bin (AIX box with Oracle 10g on it)

Load the java class into Oracle as a Java Class object type:
loadjava -user zora03_dbo/zora03_dbo@zora03 -force -resolve -verbose -synonym -grant public /app/zora03/releaseTLM2.0.0.2.8/bin/Hello.class

Create a pl/sql function wrapper for the Hello.sayIt method:
CREATE OR REPLACE FUNCTION hello_there (to_whom IN VARCHAR2)
   RETURN VARCHAR2
   AS LANGUAGE JAVA
   NAME 'Hello.sayIt(java.lang.String) return java.lang.String';
/

Test running the sayIt method:
BEGIN
   DBMS_OUTPUT.PUT_LINE(hello_there('world'));
END;
/

Error message returned:
ERROR at line 1:
ORA-29531: no method sayIt in class Hello
ORA-06512: at "ZORA03_DBO.HELLO_THERE", line 1
ORA-06512: at line 2

I have checked that Oracle believes the java class is OK by issuing the following:
select * from user_objects where object_type = 'JAVA CLASS';
And object Hello has a status of VALID

The zora03_dbo user has 'dba' privilege and is the owner of the Hello object...
Any help gratefully received!



Start Free Trial