Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-16102: remote information is not available on the specified primary

1 Answers  


ORA-15123: ASM file name 'string' contains an invalid incarnation number

1 Answers  


NID-00604: No control files found in database

1 Answers  


ORA-25437: duplicate table value for table alias: string

1 Answers  


KUP-04045: unexpected OCI status string

1 Answers  






ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 Answers  


NZE-29037: No certificate is present

1 Answers  


RMAN-08037: channel string: unexpected validation return code string

1 Answers  


ORA-12318: database (link name string) is already mounted

1 Answers  


NID-00603: No datafiles found in database

1 Answers  


ORA-14264: table is not partitioned by Composite Range method

1 Answers  


ORA-33050: (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.

1 Answers  






Categories