Hi folks

This is just a general question.

Suppose I have a SP that has several params and this includes one optional
param.

If I have all the params as args for the WS, and suppose for a particular
case there is no data in the calling app for the optional param in the SP
(note that there are no optional params for the WS because of SOAP).

Would the following approach work?

For the calling app - have a value for the optional SP param set to a value
that will never happen (eg say 0 for an int datatype that is say a foreign
key).

For the WS - have some code included that would check for that value and
then in the call to the SP - dont include a value for the optional param.

Hope somebody can help.  Thanks in advance.

Kind regards

Ross Petersen