java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Oracle Community | user9534610 | 4 years ago
  1. 0

    ORA-01722: INVALID NUMBER ERROR THROWN in suppliers accounting page

    Oracle Community | 4 years ago | user9534610
    java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  2. 0

    oracle.jbo.SQLStmtException:JBO-27122:SQLerror during statement preparation

    Oracle Community | 6 years ago | 837397
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Error when i create a resourse

    Oracle Community | 5 years ago | 882688
    java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
  5. 0

    How to set table cell color dynamically based on certain conditions

    Oracle Community | 3 years ago | 949902
    java.sql.SQLSyntaxErrorException: ORA-00904: "PCE"."OBJECT_NAME": invalid identifier

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    ORA-01722: invalid number

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
    4 frames
  4. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
    1 frame
  5. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
    2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
    3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
    4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
    5 frames
  6. oracle.apps.fnd
    OADataBoundValueLovChoiceData.getValue
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    2. oracle.apps.fnd.framework.webui.OADataBoundValueLovChoiceData.getValue(OADataBoundValueLovChoiceData.java:273)
    2 frames
  7. oracle.cabo.ui
    BaseUINode.render
    1. oracle.cabo.ui.collection.DataObjectListNodeList.getDataObjectList(Unknown Source)
    2. oracle.cabo.ui.collection.DataObjectListNodeList.size(Unknown Source)
    3. oracle.cabo.ui.BaseUINode.getIndexedChildCount(Unknown Source)
    4. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    5. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    6. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    7. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    8. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    9. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    10. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    11. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    12. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer._hasTable(Unknown Source)
    13. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
    14. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    15. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    16. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    17. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    18. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
    19. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    20. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    21. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    22. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    23. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    24. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    25. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    26. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    27. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    28. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    29. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    30. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    31. oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
    32. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    33. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    34. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    35. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    36. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    37. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    38. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    39. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    40. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    41. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    42. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    43. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source)
    44. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    45. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    46. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    47. oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source)
    48. oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source)
    49. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    50. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    51. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    52. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    53. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    54. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    55. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    56. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    57. oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
    58. oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderTableContent(Unknown Source)
    59. oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source)
    60. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    61. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    62. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    63. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    64. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    65. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    66. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    67. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    68. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    69. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    70. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    71. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    72. oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
    73. oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
    74. oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source)
    75. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    76. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    77. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    78. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    79. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    80. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    81. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    82. oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
    83. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    84. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    85. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    86. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    87. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    88. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    89. oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source)
    90. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    91. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    91 frames
  8. oracle.apps.fnd
    OABodyBean.render
    1. oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:403)
    1 frame
  9. oracle.cabo.ui
    PartialPageUtils.renderPartialPage
    1. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    2. oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
    3. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    4. oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
    5. oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
    6. oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source)
    7. oracle.cabo.ui.BaseRenderer.render(Unknown Source)
    8. oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source)
    9. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    10. oracle.cabo.ui.BaseUINode.render(Unknown Source)
    11. oracle.cabo.ui.partial.PartialPageUtils.renderPartialPage(Unknown Source)
    11 frames
  10. oracle.apps.fnd
    OAPageBean.renderDocument
    1. oracle.apps.fnd.framework.webui.OAPageBean.render(OAPageBean.java:3604)
    2. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3250)
    3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3055)
    3 frames