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
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 1 decade 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 5 months ago
27 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