aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLException Parameter Conflict" Watch "SQLException Parameter Conflict" New topic
Author

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:
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

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: http://aspose.com/file-tools
 
subject: SQLException Parameter Conflict