PLS-00397: Type mismatch in arguments to IN

PLS-00397: Type mismatch in arguments to IN
Cause: In a test for set membership such as X IN (Y, Z), the expressions X, Y, and Z do not match in datatype, and it is unclear which implicit conversion is required to correct the mismatch.
Action: Change the expressions so that their datatypes match. You might want to use datatype conversion functions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00397：参数中IN类型不匹配,
.原因：在X IN（Y，Z）的集合成员关系测试中，表达式X，Y和Z在数据类型中不匹配，并且不清楚需要哪个隐式转换来纠正不匹配。,
.操作：更改表达式，使其数据类型匹配。您可能需要使用数据类型转换功能。,
.

aiaiDBA

13718043309

010-86462881

PLS-00397: Type mismatch in arguments to IN

1 个回答

相似问题