How to fix the Oracle error PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header?

In this post, you’ll learn more about the Oracle ErrorPLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

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

You can fix this error in Oracle by following the below steps

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