java.sql.SQLSyntaxErrorException: 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 Oracle Community by 735362, 1 year ago
ORA-01722: invalid number
via Oracle Community by 811487, 1 year ago
ORA-00942: table or view does not exist
via Oracle Community by user12840707, 1 year ago
ORA-00904: "RCM"."RCM_DELETE": invalid identifier
via Oracle Community by 670947, 1 year ago
ORA-00904: "ORC_KEY": invalid identifier
via Google Groups by Marc, 9 months ago
ORA-00907: Rechte Klammer fehlt INFO | jvm 1 | 2011/01/04 15:50:24 |
via Oracle Community by 790345, 1 year ago
ORA-00903: invalid table name
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)	at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)	at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)	at com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)	at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)	at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)	at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)	at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)	at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)	at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)	at com.thortech.xl.ejb.beansimpl.tcITResourceInstanceOperationsBean.findITResourceInstances(Unknown Source)	at com.thortech.xl.ejb.beansimpl.tcITResourceInstanceOperationsBean.findITResourceInstances(Unknown Source)	at com.thortech.xl.ejb.beans.tcITResourceInstanceOperationsSession.findITResourceInstances(Unknown Source)	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:597)	at org.jboss.invocation.Invocation.performCall(Invocation.java:359)	at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)	at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)	at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)	at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)	at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)	at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)	at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)	at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)	at org.jboss.ejb.Container.invoke(Container.java:960)	at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)	at org.jboss.invocation.unified.server.UnifiedInvoker.invoke(UnifiedInvoker.java:231)	at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)	at javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288)	at $Proxy14.invoke(Unknown Source)	at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809)	at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:608)	at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:420)	at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:173)