SQLException Parameter Type Conflict

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.

[849 byte] By [rallapallia] at [2007-11-27 8:59:25]