Re: PL/SQL: Procedure with variable number of parameters ?

Hello,
 There are two methods that i have used:

1. Procedure overloading.
2. Declare your parameters with default values.

I (almost) always use 'named parameter association' when calling PL/SQL procedures (wherever i can).

Alas, when calling DB (packaged ) procedures from forms 4.5, all the parameters have to be specified.

graham (aka grumpy)

fmaesen_at_luc.ac.be (Frank Maesen), thoughtfully produced:

>Dear all,
>
>Can anybody explain how to create a procedure in PL/SQL which can accept
>a variable number of parameters.
>
>Frank Maesen

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost. Received on Sat Mar 29 1997 - 00:00:00 CST