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

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

Cause: 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 , .. );

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