Oracle Error PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header

Oracle Error Message

PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header

Reason for the Error

The class name defined as part of the method signature does not match the one defined in the type header in the EXTERNAL NAME clause. create type foo as object EXTERNAL NAME ‘foo’ LANGUAGE JAVA (… MEMBER FUNCTION my (number) return number EXTERNAL NAME ‘bar.func(oracle.sql.NUMBER) return oracle.sql.NUMBER’, .. );

Solution

Either omit the class name from the method signature or use the one defined in the type header.