java.sql.SQLException: ORA-04063: view "XXXXX oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698) org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112) org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:122)
Solution:- If it is not finding related view we will get this error.To fix issue we need to create related view.
No comments:
Post a Comment