PLS-01451: The data types of these must be comparable

PLS-01451: The data types of these <value expressions> must be comparable

PLS-01451: The data types of these must be comparable
Cause: The data types of these must be comparable. Section 4.2 of X3H2, "Data types", states that: "A character string and a number are not comparable values." Many builtin functions in STANDARD will be flagged with this warning by means of a pragma. This warning will be place on data-type coercion functions, for example, TO_CHAR(), that are inserted in OracleSQL to allow non-conforming data type combinations.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:03

PLS-01451：这些的数据类型必须是可比较的,
.原因：这些的数据类型必须是可比较的。X3H2的第4.2节“数据类型”，指出：“一个字符串和数量没有可比性值。” STANDARD中的许多内置函数将通过一个编译指示用此警告标记。这种警告将放在数据类型强制功能（例如，TO_CHAR（））上，这些函数插入到OracleSQL中以允许不合规的数据类型组合。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

PLS-01451: The data types of these <value expressions> must be comparable

1 个回答

相似问题