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

Oracle Community | user591174-Oracle | 4 years ago
  1. 0

    Export Advance Table Data Error

    Oracle Community | 4 years ago | user591174-Oracle
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  2. 0

    Error of modified query in VO

    Oracle Community | 7 years ago | 539838
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  3. 0

    Problem with Using named parameters in view Object Sql Statement

    Oracle Community | 6 years ago | HaroonAfridi
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    problem with LOV query

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

    extended VO JBO-27122: SQL error during statement preparation

    Oracle Community | 5 years ago | 927149
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1

    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

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

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.setObjectAtName
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
      3. oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:8210)
      3 frames
    3. oracle.jbo.server
      ViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3916)
      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)
      6 frames