PLS-00383: type mismatch found at 'string' inside an IN or NOT IN clause

PLS-00383: type mismatch found at 'string' inside an IN or NOT IN clause
Cause: In a test for set membership such as X NOT IN (SELECT Y ... ), the expressions X and Y 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 in the select list.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00383：IN或NOT IN子句中的“ string ”中找到类型不匹配,
.原因：在X NOT IN（SELECT Y ...）中设置成员资格的测试中，表达式X和Y在数据类型中不匹配，并且不清楚需要哪个隐式转换来纠正不匹配。,
.操作：更改表达式，使其数据类型匹配。您可能希望在选择列表中使用数据类型转换功能。,
.

aiaiDBA

13718043309

010-86462881

PLS-00383: type mismatch found at 'string' inside an IN or NOT IN clause

1 个回答

相似问题