Return
-
Title
ORA-00932 inconsistent datatypes when performing an explain plan -
Description
Toad
The user recieves an ORA- 00932 when performing an explain plan on a statement that has a Bind Variable.
For Example:
SELECT deviceid, tstamp, stat_type, status
FROM stat_time_ind
WHERE deviceid = :b1
AND TRUNC (tstamp, 'HH') + 1 / (24 * 60 * 60) =
TRUNC (:b2, 'HH') + 1 / (24 * 60 * 60)
AND stat_type = :b3 -
Resolution
Place a Datatype Conversion in front of the variable.
For example: to_date(:b2, 'MM/DD/YYYY HH24:MI:SS'), 'HH')