java.sql.SQLException: Missing IN or OUT parameter at index:: 1

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • missing in or out parameter
    via by 2637968,
  • ODI Sequences error after deplopment: Missing IN or OUT parameter at index:: 1
    via by bb55232c-70b5-467b-aaec-a4eab129d656,
  • unable load data its getting error
    via by 904205,
  • MyBatis Error Calling Oracle Function
    via Stack Overflow by greyfox
    ,
  • Ghost index calling oracle function
    via Stack Overflow by Alvaro Gomez
    ,
  • Failed Data Load - SIL
    via by Edwin-ACE,
  • Oracle 11 r2 log error
    via GitHub by maverick1981
    ,
    • java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)

    Users with the same issue

    balintn
    balintn11 times, last one,
    Cafecanudo
    Cafecanudo2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    22 more bugmates