Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException Parameter Conflict

 
sri rallapalli
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have one stored procedure with 9 in parameters and one out parameter. In oracle the OUT parameter was declared as BINARY_INTEGER. I am sending all the arguments correclt, and for the 10th argument i specified like the following:
cs.registerOutParameter(10,java.sql.Types.INTEGER);
I am not sure whether the above is correct or worg, and i did not get any errors while compiling. now i am trying to execute the StoredProcedure, after cs.execute();, it was giving the "SQLException Parameter Conflict"
Any light on this, where could be the problem lies.

thanks in advance,
Sri.
 
Gaurav Chikara
Ranch Hand
Posts: 412
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try giving the out paramater as INTEGER on both places and that will help you understand the root cause of the problem
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic