Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: Procedure with variable number of parameters ?

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

From: Dana Stockler <stockler_at_ingdata.no>
Date: 1997/03/26
Message-ID: <01bc39dc$f71506f0$8a0c8fc2@pcs_ws10>#1/1

As far as I know, it is not possible to have a variable number of parameters in a PL/SQL procedure in the 'C' sense.

However, clever use of the default parameter mechanism can be used to simulate multiple parameters.

-
Dana

Frank Maesen <fmaesen_at_luc.ac.be> wrote in article <5hatpa$2eo_002_at_news.belnet.be>...
| Dear all,
|
| Can anybody explain how to create a procedure in PL/SQL which can accept
| a variable number of parameters.
|
| Frank Maesen
|
Received on Wed Mar 26 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US