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.
