java.sql.SQLException: ORA-06550: line 1, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 868733, 1 year ago
ORA-06550: line 1, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored
via Oracle Community by 843853, 1 year ago
ORA-06550: line 1, column 7: PLS-00221: 'PA_SEARCH_NOTES' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Stack Overflow by user1344022
, 10 months ago
ORA-06550: line 1, column 7: PLS-00201: identifier 'SCHEMA_RESTORE.RESTORE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via dolinked.com by Unknown author, 2 years ago
ORA-06550: line 1, column 7: PLS-00201: identifier 'SCHEMA_RESTORE.RESTORE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Oracle Community by 441217, 1 year ago
ORA-01403: no data found ORA-06512: at "db.packageA", line 2639 ORA-06512: at line 1
via Google Groups by Aswin Dinakar, 4 months ago
ORA-00600: internal error code, arguments: [12760], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kodpunp1], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kope2upic954], [], [], [], [], [], [], []
java.sql.SQLException: ORA-06550: line 1, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2154)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2880)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:622)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:698)
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:371)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5108)
at xxcrnx.oracle.apps.ont.custrlines.schema.server.CollegeImpl.doDML(CollegeImpl.java:71)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4015)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1676)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2694)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2540)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1783)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:1976)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:680)
at xxcrnx.oracle.apps.ont.custrlines.server.XxcrnxAMImpl.saveTransaction(XxcrnxAMImpl.java:47)
at xxcrnx.oracle.apps.ont.custrlines.webui.XxcustconsetupcreaCO.processFormRequest(XxcustconsetupcreaCO.java:50)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 10 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.