java.sql.SQLSyntaxErrorException: ORA-00904: “CE”.”BLOCK_STATUS”: invalid identifier
<code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[dbcp-6.0.37.jar:6.0.37]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[dbcp-6.0.37.jar:6.0.37]
at com.jnj.she.sam.dataaccess.AbstractPreparedJDBCManager.findByPreparedStatement(AbstractPreparedJDBCManager.java:359) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at com.jnj.she.sam.dataaccess.AbstractPreparedJDBCManager.findByPreparedStatement(AbstractPreparedJDBCManager.java:296) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at com.jnj.she.cea.dataaccess.ContractorEmployeeJDBCManager.findContractorEmployees(ContractorEmployeeJDBCManager.java:803) [classes/:?]
at com.jnj.she.cea.manager.ContractorEmployeeManager.searchContractorEmployee(ContractorEmployeeManager.java:341) [classes/:?]
at com.jnj.she.cea.formhandlers.SearchContractorFormHandler.customBeforeGet(SearchContractorFormHandler.java:33) [classes/:?]
at com.jnj.she.cea.formhandlers.AbstractCeaFormHandler.beforeGet(AbstractCeaFormHandler.java:36) [classes/:?]
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_371]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_371]
at atg.taglib.dspjsp.AbstractEMFTag.resolveName(AbstractEMFTag.java:45) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at atg.taglib.dspjsp.InputTag.createInputTag(InputTag.java:162) [classes/:0.1.5-SNAPSHOT]
at atg.taglib.dspjsp.InputTag.doStartTag(InputTag.java:112) [classes/:0.1.5-SNAPSHOT]
at org.apache.jsp.elements.search.search_005fcontractor_jsp._jspx_meth_dsp_005finput_005f0(search_005fcontractor_jsp.java:1304) [she_cea/:?]
</code>
<code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[dbcp-6.0.37.jar:6.0.37]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[dbcp-6.0.37.jar:6.0.37]
at com.jnj.she.sam.dataaccess.AbstractPreparedJDBCManager.findByPreparedStatement(AbstractPreparedJDBCManager.java:359) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at com.jnj.she.sam.dataaccess.AbstractPreparedJDBCManager.findByPreparedStatement(AbstractPreparedJDBCManager.java:296) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at com.jnj.she.cea.dataaccess.ContractorEmployeeJDBCManager.findContractorEmployees(ContractorEmployeeJDBCManager.java:803) [classes/:?]
at com.jnj.she.cea.manager.ContractorEmployeeManager.searchContractorEmployee(ContractorEmployeeManager.java:341) [classes/:?]
at com.jnj.she.cea.formhandlers.SearchContractorFormHandler.customBeforeGet(SearchContractorFormHandler.java:33) [classes/:?]
at com.jnj.she.cea.formhandlers.AbstractCeaFormHandler.beforeGet(AbstractCeaFormHandler.java:36) [classes/:?]
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_371]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_371]
at atg.taglib.dspjsp.AbstractEMFTag.resolveName(AbstractEMFTag.java:45) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at atg.taglib.dspjsp.InputTag.createInputTag(InputTag.java:162) [classes/:0.1.5-SNAPSHOT]
at atg.taglib.dspjsp.InputTag.doStartTag(InputTag.java:112) [classes/:0.1.5-SNAPSHOT]
at org.apache.jsp.elements.search.search_005fcontractor_jsp._jspx_meth_dsp_005finput_005f0(search_005fcontractor_jsp.java:1304) [she_cea/:?]
</code>
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) ~[ojdbc7-12.1.0.2.jar:12.1.0.2.0]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[dbcp-6.0.37.jar:6.0.37]
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[dbcp-6.0.37.jar:6.0.37]
at com.jnj.she.sam.dataaccess.AbstractPreparedJDBCManager.findByPreparedStatement(AbstractPreparedJDBCManager.java:359) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at com.jnj.she.sam.dataaccess.AbstractPreparedJDBCManager.findByPreparedStatement(AbstractPreparedJDBCManager.java:296) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at com.jnj.she.cea.dataaccess.ContractorEmployeeJDBCManager.findContractorEmployees(ContractorEmployeeJDBCManager.java:803) [classes/:?]
at com.jnj.she.cea.manager.ContractorEmployeeManager.searchContractorEmployee(ContractorEmployeeManager.java:341) [classes/:?]
at com.jnj.she.cea.formhandlers.SearchContractorFormHandler.customBeforeGet(SearchContractorFormHandler.java:33) [classes/:?]
at com.jnj.she.cea.formhandlers.AbstractCeaFormHandler.beforeGet(AbstractCeaFormHandler.java:36) [classes/:?]
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_371]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_371]
at atg.taglib.dspjsp.AbstractEMFTag.resolveName(AbstractEMFTag.java:45) [SHESam-0.1.5-SNAPSHOT-classes.jar:0.1.5-SNAPSHOT]
at atg.taglib.dspjsp.InputTag.createInputTag(InputTag.java:162) [classes/:0.1.5-SNAPSHOT]
at atg.taglib.dspjsp.InputTag.doStartTag(InputTag.java:112) [classes/:0.1.5-SNAPSHOT]
at org.apache.jsp.elements.search.search_005fcontractor_jsp._jspx_meth_dsp_005finput_005f0(search_005fcontractor_jsp.java:1304) [she_cea/:?]
i am getting this error while running code.Could anyone suggest.
New contributor
Shimmi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.