Re: undefined number of parameters

> my interpretation of the quesiton was that he has no idea how many
> parameters he will ever need. dynamic pl/sql is the only way to go and
> as I said, its probably not scalable.
>
> maybe I misinterpreted the question?

I think you understood it correctly. That's why Connor's approach is probably the way to go. Instead of creating a function that will take any number of parameters (which will have to be changed dynamically as you've stated), why not pass one parameter with unlimited values in that parameter? Similar to passing a linked list to a function in C or C++.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"