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

Oracle Community | Hanimi | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    Oracle Community | 6 years ago | Hanimi
    java.sql.SQLException: ORA-01722: invalid number
  2. 0

    problem with seeded extension example - adding supplier site

    Oracle Community | 1 decade ago | 491697
    java.sql.SQLException: ORA-01722: invalid number
  3. 0

    Lov Crashes even b4 reaching to PR

    Oracle Community | 10 years ago | 533926
    java.sql.SQLException: ORA-01722: invalid number
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error for a custom OAF page

    Oracle Community | 4 years ago | user2626293
    java.sql.SQLException: ORA-01722: invalid number
  6. 0

    Custom Page gives error for one particular FND_USER

    Oracle Community | 9 years ago | Devang Thakkar
    java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

  1. rp 1 times, last 2 months ago
26 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.SQLException

    ORA-01722: invalid number

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2559)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2950)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:582)
    4 frames
  5. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:627)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:515)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3347)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:825)
    4 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4465)
    1 frame
  7. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
    3. oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
    4. oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3311)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3298)
    5 frames
  8. oracle.apps.fnd
    MsgAttrVOImpl.initQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    2. oracle.apps.fnd.wf.worklist.server.MsgAttrVOImpl.initQuery(MsgAttrVOImpl.java:39)
    2 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:324)
    4 frames
  10. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:189)
    2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:152)
    3. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1086)
    4. oracle.apps.fnd.wf.worklist.server.WorklistAMImpl.initializeWebValues(WorklistAMImpl.java:106)
    5. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.initializeWebValues(OAWebBeanContainerHelper.java:527)
    6. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2110)
    7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1711)
    8. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
    9. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
    9 frames
  11. oa_html
    _OA._jspService
    1. oa_html._OA._jspService(_OA.java:88)
    1 frame
  12. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  13. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  14. oracle.jsp
    JspServlet.service
    1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
    2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
    3. oracle.jsp.JspServlet.service(JspServlet.java:156)
    3 frames
  15. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  16. oracle.jsp.provider
    Jsp20RequestDispatcher.forward
    1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
    1 frame
  17. oracle.jsp.runtime
    OraclePageContext.forward
    1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
    1 frame
  18. oa_html
    _OA._jspService
    1. oa_html._OA._jspService(_OA.java:98)
    1 frame
  19. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  20. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  21. oracle.jsp
    JspServlet.service
    1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
    2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
    3. oracle.jsp.JspServlet.service(JspServlet.java:156)
    3 frames
  22. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  23. oracle.jsp.provider
    Jsp20RequestDispatcher.forward
    1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
    1 frame
  24. oracle.jsp.runtime
    OraclePageContext.forward
    1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
    1 frame
  25. oa_html
    _OA._jspService
    1. oa_html._OA._jspService(_OA.java:98)
    1 frame
  26. oracle.jsp.runtime
    HttpJsp.service
    1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
    1 frame
  27. oracle.jsp.app
    JspApplication.dispatchRequest
    1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
    1 frame
  28. oracle.jsp
    JspServlet.service
    1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
    2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
    3. oracle.jsp.JspServlet.service(JspServlet.java:156)
    3 frames
  29. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
    1 frame
  30. org.apache.jserv
    JServConnection.run
    1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
    2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
    2 frames
  31. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:534)
    1 frame