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

Oracle Community | Avaneesh Jain | 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

    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 | 8 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

  1. rp 1 times, last 3 months ago
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