Re: Counting arguments passed to SQL or PL/SQL?

I would use a dynamic sql anf form it based on the input parameters sent. I have a similar procedure where about 20 input pparameters can be sent or some of them can be null. Depending on the values sent I form the dynamic sql. It is working and fast. Hope that helps.

-Venki

Jeff Wilson wrote:

> Have checked all the on-line FAQs but can't find the answer to this.
>
> Have a PL/SQL script that takes optional arguments for switches and such. I
> know &1, &2, etc., represent these arguments, but is there a variable that
> represents the number of arguments?
>
> The problem I'm having is that if a variable is not passed in, then SQL asks
> for it's value if it is encountered in the script. I need some way of
> knowing if a variable is set.
>
> Thanks.
>
> --
> Jeff Wilson
> jwilson2000_at_home.com
> Eugene, Oregon
>
> (541) 684-8590
Received on Thu Jul 19 2001 - 16:48:53 CDT