posted 20 years ago
Hi,
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:
{call test_order(?,?,?)}
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!