Question

为什么同一句sql在plsql可以但在jdbc中就显示table or view does not exist?

sql = insert into TR_DEL values ('M110319-0615',null)
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:111)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:473)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1450)
at com.test.PingBi.to_hide(PingBi.java:21)
at com.test.PingBi.main(PingBi.java:34)
原来是配置出错了，呵呵

若以下回答无法解决问题，邀请你更新回答

Answer 1

如果没有跨数据库的话不应该的啊