SQL error “ORA-01722: invalid number”

An ORA-01722 error occurs when an attempt is made to convert a character string into a number, and the string cannot be converted into a number.

Without seeing your table definition, it looks like you’re trying to convert the numeric sequence at the end of your values list to a number, and the spaces that delimit it are throwing this error. But based on the information you’ve given us, it could be happening on any field (other than the first one).

Related Posts:

  1. SQL error “ORA-01722: invalid number”
  2. QL Error: ORA-00933: SQL command not properly ended
  3. SQL Error: ORA-00942 table or view does not exist
  4. SQL not a single-group group function
  5. PLS-00201 – identifier must be declared
  6. PLS-00103: Encountered the symbol when expecting one of the following:
  7. SQL Error: ORA-00913: too many values
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Is there a combination of “LIKE” and “IN” in SQL?
  10. SQL Error: ORA-01861: literal does not match format string 01861
  11. ORA-01747: invalid user.table.column, table.column, or column specification
  12. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  13. SQL Queries “00904. 00000 – “%s: invalid identifier”
  14. ‘NOT LIKE’ in an SQL query
  15. ORA-01779: cannot modify a column which maps to a non key-preserved table
  16. ORA-00904: invalid identifier
  17. Convert String to double in Java
  18. how to fix oracle ORA-01722 invalid number error
  19. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  20. ORA-00979 not a group by expression
  21. ORA-00907: missing right parenthesis
  22. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  23. How do I convert a string to a number in PHP?
  24. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  25. ORA-28040: No matching authentication protocol exception
  26. ORA-01843 not a valid month- Comparing Dates
  27. ORA-00918: column ambiguously defined in SELECT *
  28. ORA-00984: column not allowed here [duplicate]
  29. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  30. How to resolve ORA 00936 Missing Expression Error?
  31. Oracle error : ORA-00905: Missing keyword
  32. What does SQL Select symbol || mean?
  33. How do I limit the number of rows returned by an Oracle query after ordering?
  34. Oracle SELECT TOP 10 records
  35. issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
  36. Can a foreign key be NULL and/or duplicate?
  37. How to Select Top 100 rows in Oracle?
  38. ORA-30926: unable to get a stable set of rows in the source tables
  39. ORA-12560: TNS:protocol adaptor error
  40. Convert an integer to an array of characters : java
  41. PLS-00103: Encountered the symbol “CREATE”
  42. Oracle client ORA-12541: TNS:no listener
  43. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  44. What does the following Oracle error mean: invalid column index
  45. How do I check if a string is a number (float)?
  46. ORA-00972 identifier is too long alias column name
  47. No more data to read from socket error
  48. What does the following Oracle error mean: invalid column index
  49. Oracle Apex column link from LOV values
  50. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  51. ORA-12899: value too large for column
  52. Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
  53. ORA-00918: column ambiguously defined in SELECT *
  54. ORA-00918: column ambiguously defined in SELECT *
  55. Oracle date format picture ends before converting entire input string
  56. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  57. SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  58. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  59. ORA-01861: literal does not match format string
  60. ORA-01653: unable to extend table by in tablespace ORA-06512
  61. What is it exactly a BLOB in a DBMS context
  62. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  63. ORA-28001: The password has expired
  64. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  65. Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
  66. How do you create a temporary table in an Oracle database?
  67. Oracle “Partition By” Keyword
  68. How to insert date values into table
  69. Oracle SQL: Update a table with data from another table
  70. Oracle SQL query for Date format
  71. sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
  72. How to execute an oracle stored procedure?
  73. What is the Oracle equivalent of SQL Server’s IsNull() function?
  74. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  75. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  76. C convert floating point to int
  77. SQL selecting rows by most recent date with two unique columns
  78. Comparing Dates in Oracle SQL
  79. Convert timestamp to date in Oracle SQL
  80. How do I reset a sequence in Oracle?
  81. How to display databases in Oracle 11g using SQL*Plus
  82. grant select on view
  83. Update statement with inner join on Oracle
  84. MySQL equivalent of DECODE function in Oracle
  85. Hibernate dialect for Oracle Database 11g?
  86. Query to display all tablespaces in a database and datafiles
  87. ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
  88. Oracle: If Table Exists
  89. DATEDIFF function in Oracle
  90. How to create id with AUTO_INCREMENT on Oracle?
  91. LEFT function in Oracle
  92. Convert double to float by cast or Convert.ToSingle()?
  93. What is the difference between Views and Materialized Views in Oracle?
  94. How can I set a custom date time format in Oracle SQL Developer?
  95. How to copy files into a virtual box oracle box
  96. How do I view the Explain Plan in Oracle Sql developer?
  97. ORA-01735: invalid ALTER TABLE option – Toad
  98. Find out the history of SQL queries
  99. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  100. PLS-00049 bad bind variable While using :OLD

Leave a Comment

tech