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 | 5 years ago
  1. 0

    Exception while inserting the data into custom table

    Oracle Community | 5 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 | 9 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

    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