Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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