Why does executing the PreparedStatement class cause a “TRUNC fails: ORA-00932: inconsistent datatypes” error?
According to Oracle Metalink Bug Database Doc ID: 144784.1, in the absence of explicit data typecasting, OCI assumes that a bind variable is a CHAR data type. If the SQL statement intends to use the bind variable as a DATE data type, but OCI thought it was a CHAR, the SQL parser will have a conflict in data types. The fix is to explicitly use data conversion functions to convert the bind variables in the problem queries. For example, a select string of String st = “select count(*) from simple_table where TRUNC(mydate) = TRUNC(?)”; should be changed to: String st = “select count(*) from simple_table where TRUNC(mydate) = TRUNC(TO_DATE(?
A. According to Oracle Metalink Bug Database Doc ID: 144784.1, in the absence of explicit data typecasting, OCI assumes that a bind variable is a CHAR data type. If the SQL statement intends to use the bind variable as a DATE data type, but OCI thought it was a CHAR, the SQL parser will have a conflict in data types. The fix is to explicitly use data conversion functions to convert the bind variables in the problem queries. For example, a select string of String st = “select count(*) from simple_table where TRUNC(mydate) = TRUNC(?)”; should be changed to: String st = “select count(*) from simple_table where TRUNC(mydate) = TRUNC(TO_DATE(?
According to Oracle Metalink Bug Database Doc ID: 144784.1, in the absence of explicit data typecasting, OCI assumes that a bind variable is a CHAR data type. If the SQL statement intends to use the bind variable as a DATE data type, but OCI thought it was a CHAR, the SQL parser will have a conflict in data types. The fix is to explicitly use data conversion functions to convert the bind variables in the problem queries. For example, a select string of String st = “select count(*) from simple_table where TRUNC(mydate) = TRUNC(?)”; should be changed to: String st = “select count(*) from simple_table where TRUNC(mydate) = TRUNC(TO_DATE(?))”; 42.
Related Questions
- Sometimes, a control action fails, but the error message does not always help me pinpoint the true cause of the problem. How can I figure out what was the source of the error?
- When trying to print reports, I get an error message "Cannot shift objects off sheet" or Cashflow Plan fails to hide columns in certain reports?
- Why does executing the PreparedStatement class cause a "TRUNC fails: ORA-00932: inconsistent datatypes" error?
