SQLException Parameter Type Conflict
843859Jun 27 2007 — edited Jun 28 2007Hi 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.