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

Oracle Community | 868733 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Exception while inserting the data into custom table

    Oracle Community | 6 years ago | 868733
    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
  2. 0

    Urgent: Getting a oracle.jbo.DMLException: JBO-26041

    Oracle Community | 1 decade ago | 459203
    java.sql.SQLException: ORA-00001: unique constraint (GESSS.GECM_COMM_ID_CAT_ID_CMP_IDX) violated
  3. 0

    Urgent : Facing an error after deploying Extended EO

    Oracle Community | 10 years ago | 576717
    java.sql.SQLException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL Error exception handling

    Oracle Community | 10 years ago | 529922
    java.sql.SQLException: ORA-20101: There is already an active record for your record X ORA-06512: at "APPS.XXGL_FRS_ACCT_MAPPING_TR", line 63 ORA-06512: at "APPS.XXGL_FRS_ACCT_MAPPING_TR_ST", line 3 ORA-04088: error during execution of trigger 'APPS.XXGL_FRS_ACCT_MAPPING_TR_ST'
  6. 0

    Unable to insert data into NCLOB!

    Oracle Community | 1 decade ago | 68375
    java.sql.SQLException: ORA-12704: character set mismatch

  1. rp 1 times, last 3 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.execute
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2154)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2036)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2880)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:622)
    5. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:698)
    5 frames
  5. oracle.jbo.server
    EntityImpl.doDML
    1. oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:371)
    2. oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5108)
    2 frames
  6. xxcrnx.oracle.apps
    CollegeImpl.doDML
    1. xxcrnx.oracle.apps.ont.custrlines.schema.server.CollegeImpl.doDML(CollegeImpl.java:71)
    1 frame
  7. oracle.jbo.server
    EntityImpl.postChanges
    1. oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4015)
    1 frame
  8. oracle.apps.fnd
    OAEntityImpl.postChanges
    1. oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1676)
    1 frame
  9. oracle.jbo.server
    DBTransactionImpl.commit
    1. oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2694)
    2. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2540)
    3. oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1783)
    4. oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:1976)
    4 frames
  10. oracle.apps.fnd
    OADBTransactionImpl.commit
    1. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:680)
    1 frame
  11. xxcrnx.oracle.apps
    XxcustconsetupcreaCO.processFormRequest
    1. xxcrnx.oracle.apps.ont.custrlines.server.XxcrnxAMImpl.saveTransaction(XxcrnxAMImpl.java:47)
    2. xxcrnx.oracle.apps.ont.custrlines.webui.XxcustconsetupcreaCO.processFormRequest(XxcustconsetupcreaCO.java:50)
    2 frames
  12. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
    18 frames