Seems that the problem is with the parameterized SQL query.
When you tell the query that there will be 5 parameters it MUST have them.
If it can not find them it will ask.
You need to deal with the argument count ambiguity.
For example if you list is a set of possible values of a single column
... WHERE your_col IN (?);
Take you set of possible values in the parameter list, place them in one
string, with proper quotes, and deliver a single parameter.
More details about 'switches and such' will help provide more example.
> 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.
> 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
> for it's value if it is encountered in the script. I need some way of
> knowing if a variable is set.
> Jeff Wilson
> Eugene, Oregon
> (541) 684-8590