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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00970：方法的类名必须与类型头中的EXTERNAL NAME子句匹配,
.原因：定义为方法签名一部分的类名称与EXTERNAL NAME子句中类型头中定义的类名不匹配。创建类型foo作为对象EXTERNAL NAME'foo'LANGUAGE JAVA（... MEMBER FUNCTION my（number）return number EXTERNAL NAME'bar.func（oracle.sql.NUMBER）return oracle.sql.NUMBER'，..）;,
.操作：从方法签名中省略类名称或使用类型头中定义的类名。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题