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 accessing the DB 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

    Could not Insert New Record in DB

    Oracle Community | 4 years ago | Karthic Rajha
    java.sql.SQLException: ORA-01779: cannot modify a column which maps to a non key-preserved table ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

    1 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.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleCallableStatement.executeUpdate
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      5. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
      6. oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
      8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3074)
      10. oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4309)
      10 frames
    3. oracle.jbo.server
      EntityImpl.postChanges
      1. oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
      2. oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740)
      3. oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539)
      3 frames
    4. oracle.apps.fnd
      OAEntityImpl.postChanges
      1. oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(Unknown Source)
      1 frame
    5. oracle.jbo.server
      DBTransactionImpl.commit
      1. oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
      2. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
      3. oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971)
      4. oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
      4 frames
    6. oracle.apps.fnd
      OADBTransactionImpl.commit
      1. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(Unknown Source)
      1 frame
    7. dem.oracle.apps
      SetmynewCO.processFormRequest
      1. dem.oracle.apps.ont.wen.server.DemoAMImpl.saveTransaction(DemoAMImpl.java:44)
      2. dem.oracle.apps.ont.wen.webui.SetmynewCO.processFormRequest(SetmynewCO.java:47)
      2 frames
    8. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(Unknown Source)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(Unknown Source)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(Unknown Source)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      18 frames