File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQLException Parameter Conflict Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQLException Parameter Conflict" Watch "SQLException Parameter Conflict" New topic

SQLException Parameter Conflict

sri rallapalli
Ranch Hand

Joined: Mar 15, 2005
Posts: 88
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:
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,
Gaurav Chikara
Ranch Hand

Joined: Jun 09, 2000
Posts: 410
Try giving the out paramater as INTEGER on both places and that will help you understand the root cause of the problem

SCJP,SCWCD,SCBCD<br />If Opportunity doesn't knock then build the door
I agree. Here's the link:
subject: SQLException Parameter Conflict
jQuery in Action, 3rd edition