Solved

error while saving to oracle database table through RAD j2ee application

Posted on 2009-07-15
2
332 Views
Last Modified: 2013-12-19
Hi,

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
0
Comment
Question by:gudii9
2 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24861784
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.
0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31603855
Thank you very much
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle - SQL Parse String 5 33
how to trim oracle sql sentence in unix 17 51
hibernate example for saving data 19 37
Unhandled exception type Exception 18 28
Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question