Getting Ora-00932 error when optimizing a statement with a "date variable

Chatee ahora con Soporte

Getting Ora-00932 error when optimizing a statement with a "date variable - 1" included in it (4251211)

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Getting Ora-00932 error when optimizing a statement with a "date variable - 1" included in it
Descripción

When using the new 'Optimize Current SQL' feature in Toad for Oracle, if I try to optimize the following statement it works fine...
select ename from emp where hiredate = :v_date

However, if I add (- 1) to the end and try to optimize it, I get an 'ORA-00932: inconsistent datatypes: expected DATE got number' error.

select ename from emp where hiredate = :v_date - 1
Resolución

WORKAROUND:
None

STATUS:
Issue fixed in version 11.0. The latest version of Toad For Oracle can be downloaded at : http://support.quest.com/Search/SearchDownloads.aspx
ID de defecto

ST74452

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: Toad for Oracle; SQL Optimizer for Oracle
8.6, 8.5, 8.0

Getting Ora-00932 error when optimizing a statement with a "date variable - 1" included in it (4251211)