Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: Procedure with variable number of parameters ?
Hi Dana:
It has. You can try to define as record TYPE. It allows you to build struct as C. It is handy too.
If you need example, please e-mail to me.
Best regards,
Dana Stockler (stockler_at_ingdata.no) wrote:
: 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
: |
-- Best regards,Received on Sat Mar 29 1997 - 00:00:00 CST