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

Cause: The data types of these value_expressions must be comparable. Section 4.2 of X3H2, "Data types", states that: "A character string and a number are not comparable values." Many built-in 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(number), that are inserted in Oracle SQL to allow non-conforming data type combinations.

Action: Refer to ANSI document ANSI X3.135-1992 for details.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/