Database: MS SQL Server
Java: 1.6
The stored proc which my frontend would use has 3 input parameters with default values (NULL) for all 3 parameters.
But my frontend would use just only 1 parameter out of 3. For this I have my
JDBC code like this using the named parameter feature.
I get an error "The index 3 is out of range."
This JDBC code works fine if I pass all 3 parameters (or) if I pass only the first parameter login_id. I don�t think the JDBC CallableStatement requires same number of parameters as the backend strored proc.