java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Variable

Oracle Community | 662320 | 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

    Trying Supplier and SupplierSite Header Detail View - Getting error

    Oracle Community | 6 years ago | 662320
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Variable
  2. 0

    Andrejus Baranovskis Blog: LOV in Find Mode - Workaround for JDeveloper 11g TP4

    blogspot.com | 2 years ago
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: vc_temp_1
  3. 0

    Andrejus Baranovskis Blog: LOV in Find Mode - Workaround for JDeveloper 11g TP4

    blogspot.nl | 9 months ago
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: vc_temp_1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Attempt to set a parameter name that does not occur in the SQL: Variable

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.setNullAtName
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
      3. oracle.jdbc.driver.OraclePreparedStatement.setNullAtName(OraclePreparedStatement.java:3917)
      3 frames
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3946)
      2. oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      3. oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:13759)
      4. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:801)
      5. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
      6. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)
      7. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      7 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(Unknown Source)
      1 frame
    5. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)
      5 frames
    6. oracle.apps.fnd
      OATableBean.queryData
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.queryData(Unknown Source)
      3. oracle.apps.fnd.framework.webui.beans.table.OATableBean.queryData(Unknown Source)
      3 frames
    7. aa.oracle.apps
      MasterDetailCO.processRequest
      1. aa.oracle.apps.ak.ViewLinkMD.webui.MasterDetailCO.processRequest(MasterDetailCO.java:49)
      1 frame
    8. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(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