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



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

Answer / guest

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 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(<number>), that are inserted in OracleSQL to allow
non-conforming data type combinations.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23359: error on creating a ddl record for a repcatlog record

1 Answers  


ORA-29542: class string already defined by source string

1 Answers  


ORA-01676: standby file name convert of 'string' exceeds maximum length of string

1 Answers  


ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified

1 Answers  


ORA-32550: Replacement occured despite hint to the contrary

1 Answers  






ORA-01322: No such table

1 Answers  


PCC-02308: identifier required in this function declaration

1 Answers  


ORA-01112: media recovery not started

1 Answers  


ORA-24780: cannot recover a transaction while in an existing transaction

1 Answers  


RMAN-06009: using target database controlfile instead of recovery catalog

1 Answers   HP,


ORA-00094: %s requires an integer value

1 Answers  


ORA-02427: create view failed

1 Answers  


Categories