oracle中ora-01722无效数字,oracle检索数据的时候报ORA-01722:无效数字解决

Java代码

java.sql.SQLException: ORA-01722: 无效数字

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)

at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)

at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4055)

at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4195)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1279)

at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)