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

Chat now with support

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

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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
Lösung

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
Fehler-ID

ST74452

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: 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)