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/