java.sql.SQLException: ORA-01843: not a valid month

Oracle Community | Avaneesh Jain | 6 years ago
  1. 0

    ERROR java.sql.SQLException: ORA-01843: not a valid month

    Oracle Community | 6 years ago | Avaneesh Jain
    java.sql.SQLException: ORA-01843: not a valid month
  2. 0

    SQL Error while VO.executequery()

    Oracle Community | 3 years ago | Debanjan Banerjee
    java.sql.SQLException: ORA-01843: not a valid month
  3. 0

    Unable to query employee in Workflow Administrator Web(New) responsibility

    Oracle Community | 7 years ago | 676090
    java.sql.SQLException: ORA-01006: bind variable does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Extend VO with "CONNECT BY" and "START WITH" clause

    Oracle Community | 8 years ago | User621094-Oracle
    java.sql.SQLException: ORA-01006: bind variable does not exist
  6. 0

    Error: while preparing dynamic sql

    Oracle Community | 8 years ago | 654564
    java.sql.SQLException: ORA-01007: variable not in select list

    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-01843: not a valid month

      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:590)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
      4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
      4 frames
    4. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)
      2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
      3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
      4 frames
    5. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)
      2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)
      3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)
      4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
      4 frames
    6. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4507)
      1 frame
    7. oracle.jbo.server
      ViewObjectImpl.executeDetailQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
      2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
      3. oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
      4. oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)
      4 frames