Re: Determine if a parameter has been passed

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Thu, 20 Sep 2007 16:02:22 -0400
Message-ID: <13f5kef1rdcu18d@corp.supernews.com>

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 Received on Thu Sep 20 2007 - 15:02:22 CDT