Error in SQL query: ORA-01722: invalid number
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We get the following error message for certain SQL queries:
ORA-01722: invalid number
Resolution:
This message indicates that you are trying to perform an operation ( = > < ) on a numeric column, such as
Z30_OPEN_DATE NUMBER(8)
where the value is not numeric.
If the query is using an "ORDERED" hint and is being done against large tables, you need to either optimize the order of the tables in the FROM clause or use the DYNAMIC SAMPLING hint instead. See KB 16384-25265.
- Article last edited: 10/8/2013