Just a quick query about IN parameters that are passed to CallableStatements. If one (or more) of the parameters has a default value created in the stored procedures SQL, how is this reflected when using the CallableStatement?
For example, if I use the following statement to create a CallableStatement object:
and the second parameter has a default value, do I have to set it anyway, or is there a way to just take the default value?
I've tried setting the first and third parameters and not the second, but I get an SQLException thrown with the error "Invalid parameter binding(s)."
Any help you can offer would be greatly appreciated!
HI ..Its good that you pass in default value... I had this problem some time back I stuck to sending default values from the bean. At a later point of time I had to change this only at particular geographicaly separated location. All I did was changed the bean only at that site. It came as great help....
Keep things Simple as world is already complex