Skip to main content
  • Subscribe by RSS
  • ExLibris Dev

    Error in SQL query: ORA-01722: invalid number

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    We get the following error message for certain SQL queries:

    ORA-01722: invalid number

    This message indicates that you are trying to perform an operation ( = > < ) on a numeric column, such as


    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
    // feedback widged