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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Hibernate JIRA by Mathias Bogaert, 1 year ago
ORA-01722: invalid number
via Hibernate JIRA by Mathias Bogaert, 1 year ago
ORA-01722: invalid number
via Oracle Community by 404001, 8 months ago
ORA-01008: not all variables bound
via Oracle Community by 3004, 1 year ago
ORA-00600: internal error code, arguments: [ttcgcshnd-1] [0], [], [], [], [], [], []
via Google Groups by Bob McAteer, 5 months ago
ORA-00600: internal error code, arguments: [ttcgcshnd-1] [0], [], [], [], [], [], []
via Oracle Community by 3004, 1 year ago
ORA-01002: fetch out of sequence
java.sql.SQLException: ORA-01722: invalid number
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1892)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2504)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2832)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:71)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:551)
at net.sf.hibernate.loader.Loader.doFind(Loader.java:140)
at net.sf.hibernate.loader.Loader.find(Loader.java:620)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:81)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3157)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:65)
at com.intrasoft.persistence.hibernate.HibernatePersistenceService.findAll(HibernatePersistenceService.java:146)
at com.intrasoft.sysaudit.reference.DefaultReferenceManager.getUnits(DefaultReferenceManager.java:90)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:255)
at ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:654)
at ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:54)
at ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:122)
at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1219)
at ognl.ASTProperty.getValueBody(ASTProperty.java:108)
at ognl.SimpleNode.getValue(SimpleNode.java:129)
at ognl.ASTChain.getValueBody(ASTChain.java:57)
at ognl.SimpleNode.getValue(SimpleNode.java:129)
at ognl.Ognl.getValue(Ognl.java:335)
at ognl.Ognl.getValue(Ognl.java:310)
at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:305)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:213)
at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:365)
at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:90)
at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:133)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:269)
at org.apache.velocity.Template.merge(Template.java:294)
at com.opensymphony.webwork.views.jsp.ui.AbstractUITag.mergeTemplate(AbstractUITag.java:511)
at jsp_servlet._views._epm.__create._jspService(__create.java:346)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:431)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at com.intrasoft.security.filter.LoginFilter.doFilter(LoginFilter.java:130)
at com.intrasoft.util.profiling.filter.ProfilingFilter.doFilter(ProfilingFilter.java:137)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:221)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:161)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:37)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.intrasoft.util.profiling.interceptor.ProfilingInterceptor.intercept(ProfilingInterceptor.java:39)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:149)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at com.intrasoft.security.filter.MultipleRolesFilter.doFilter(MultipleRolesFilter.java:75)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129)
at com.intrasoft.security.filter.LoginFilter.doFilter(LoginFilter.java:150)
at com.intrasoft.util.profiling.filter.ProfilingFilter.doFilter(ProfilingFilter.java:137)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:97)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3575)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:178)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:151)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 months ago
Samebug visitor profile picture
Unknown user
2 times, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
30 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.