• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQLException Parameter Conflict  RSS feed

 
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: 413
  • 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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!