This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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 Building Microservices this week in the Design 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
Have you checked out Aspose?
subject: SQLException Parameter Conflict
It's not a secret anymore!