• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

error while saving to oracle database table through RAD j2ee application


I am trying to save a record to oracle 10g table through RAD j2ee application. I am getting error messages like

Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 7
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
      at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1681)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3280)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:724)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:544)

Any ideas, suggestions, resources highly appreciated. Thanks in advance
1 Solution
Check that you have the correct number of parameters on the Java side of the call. It must match what the PL/SQL stored procedure expects. Post the procedure signature here if you want more help.
gudii9Author Commented:
Thank you very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now