Re: Determine if a parameter has been passed

On Thu, 20 Sep 2007 16:02:22 -0400, Walt <walt_askier_at_SHOESyahoo.com> wrote:

>fitzjarrell_at_cox.net wrote:
>> On Sep 20, 6:05 am, addve..._at_gmail.com wrote:
>>> Hi,
>>> There is a Stored procedure which has 10 parameters. All of the
>>> parameters are of type VARCHAR2. The invoker has been given the
>>> facility that, he/she may pass in only 3 out of the 10 parameters.
>>> My question is this, is it possible to determine inside the
>>> Stored procedure, whether a parameter has been passed or not by the
>>> invoker?
>>>
>>> Please note the invoker may pass NULL in any one of the parameters.
>
>> What purpose does this serve, really? Why do you 'need' to know how
>> many of the 10 parameters were actually passed values by the invoker?
>> This seems to be an exercise in futility to me.
>
>Agreed. What's the difference between the user passing in NULL and the
>user not specifying the parameter at all? Seems the same to me.
>
>//Walt

To take a wild guess, it matters which parameters will be searched. Checking for a NULL (x IS NULL) and ignoring a NULL (x=x) are two different things.

B. Received on Thu Sep 20 2007 - 15:35:00 CDT