java.sql.SQLException: ORA-01009: missing mandatory parameter

Oracle Community | 3004 | 1 decade 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

    missing mandatory parameter in 2.4.0

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  2. 0

    getObjectById() generating empty SQL statement

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  3. 0

    using Clobs

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Custom Page gives error for one particular FND_USER

    Oracle Community | 9 years ago | Devang Thakkar
    java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected
  6. 0

    BLOB datatype view link not working

    Oracle Community | 7 years ago | 678400
    java.sql.SQLException: ORA-00904: "VIEW_ATTR": invalid identifier
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-01009: missing mandatory parameter

    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:573)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
    4. oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3975)
    5. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:623)
    6. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
    6 frames
  5. com.solarmetric.datasource
    PreparedStatementWrapper.executeQuery
    1. com.solarmetric.datasource.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:93)
    1 frame
  6. com.solarmetric.kodo
    PersistenceManagerImpl.getObjectById
    1. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedQueryInternal(SQLExecutionManagerImpl.java:769)
    2. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQueryInternal(SQLExecutionManagerImpl.java:692)
    3. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:373)
    4. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:357)
    5. com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.loadByPK(ClassMapping.java:950)
    6. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.initialize(JDBCStoreManager.java:263)
    7. com.solarmetric.kodo.runtime.datacache.DataCacheStoreManager.initialize(DataCacheStoreManager.java:255)
    8. com.solarmetric.kodo.runtime.StateManagerImpl.loadInitialState(StateManagerImpl.java:174)
    9. com.solarmetric.kodo.runtime.PersistenceManagerImpl.getObjectByIdFilter(PersistenceManagerImpl.java:986)
    10. com.solarmetric.kodo.runtime.PersistenceManagerImpl.getObjectById(PersistenceManagerImpl.java:888)
    10 frames
  7. net.sundog.jdo
    JDOUtil.findByPrimaryKey
    1. net.sundog.jdo.JDOUtil.findByPrimaryKey(JDOUtil.java:120)
    1 frame
  8. net.sundog.products
    AlertTypePeer.findByPrimaryKey
    1. net.sundog.products.AlertTypePeer.findByPrimaryKey(AlertTypePeer.java:9)
    1 frame