Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-01451: The data types of these <value expressions> must
be comparable
- 1 Answers
- 2630 Views
- I also Faced
- E-Mail Answers
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 |
ORA-31195: XML node 'string' (type=string) does not support this operation
SQL*Loader-00263: PIECED column string must be last specified column in table string
RMAN-06169: could not read file header for datafile string error reason string
NZE-29024: Certificate validation failure
DRG-50900: text query parser error on line string, column string
ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.
NMP-00011: internal SNMP program interface error
ORA-16056: backup control file archival requires proper syntax
EXP-00053: unable to execute QUERY on table string because the table has inner nested tables
ORA-30351: query rewrite does not currently support this expression
PCB-00629: Host variable is not of Internal LOB type
ORA-12838: cannot read/modify an object after modifying it in parallel
Oracle Errors 
