This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
how to escape ? in commons.dbutils.QueryRunner
What am i doing wrong here? ( Stored Procedure REF CURSOR Problem)
Clob in callable statement Error
Questions about Exception handling