Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLException Parameter Type Conflict

843859Jun 27 2007 — edited Jun 28 2007
Hi All,

I have one stored procedure with 9 in parameters and 1 out parameter.
Out of the 9 In parameters, 7 are veachar in oracle, and the remining 2 are NUMBER(5), NUMBER(10).
I am setting like this.
cs.setString() --- for 7 parameters
cs.setLong() --- for 7 parameters
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 Type Conflict".

Any light on this, where could be the problem lies.

thanks in advance,
Sri.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2007
Added on Jun 27 2007
1 comment
1,221 views