I need to build a stored package procedure that can accept multiple parameters e.g. 20, however, some calls to the package will supply fewer than 20 parameters, some will provide all 20 parameters.
The values of those parameters that are supplied will be used to insert/update a table, however, for the parameters that aren't supplied the related columns in the table will be left untouched.
I'm aware that I could identify which parameters have been omitted by setting default values that would never be supplied to the procedure. This would work okay for character and date values, however it isn't possible to identify a particular numeric value that wouldn't be supplied.
I could also use overloading to handle the various numbers of parameters, but this could result in a lot of overloaded definitions of the procedure and I would prefer to do it through inspecting the data.
Is it possible to determine which parameters have NOT been supplied to a package procedure?