Re: Dynamic number of parameters

Well, PL/SQL lets you overload procedures. That is, you can use the same name for several different procedures which have different formal parameters. The number, order, or types of the parameters can be different. Reference your "PL/SQL User's Guide and Reference" from Oracle, or "Oracle PL/SQL Programming" from Oracle Press. Just look for Overloading in the index of either book.

On 5 Feb 1998 15:21:18 -0600, mjb1_at_earth.execpc.com (Michael J. Braunstein) wrote:

>I'm trying to write a PL/SQL procedure that takes a dynamic
>number of parameters, without using the old fallback, namely
>"defaults".
>Could someone help me out by either showing me a sample bit of
>code or pointing me in the right direction to a piece of
>documentation?
>
>Thanks.
Received on Thu Feb 05 1998 - 00:00:00 CST