It's not a secret anymore!
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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
It's not a secret anymore!