Re: How to get the number of args in PL/SQL program ?

From: craig sivils <casivils_at_lescsse.jsc.nasa.gov>
Date: 18 May 93 20:54:47 GMT
Message-ID: <casivils.737758487_at_node_508ba>


In <C6t4wK.Apy_at_cti.wnc.nedlloyd.nl> john_at_cti.wnc.nedlloyd.nl (John Borst) writes:

>In one of our PL/SQL programs we do not know in advance how many arguments
>will be given upon invocation. The arguments can be retrieved by means of
>the variables &1, &2, etc, but we do not know the actual number of arguments
>given to this program.
 

>Question:
 

>Is there a way to figure out what the total number of arguments given to
>a PL/SQL program is ? In other words is there an equivalent in PL/SQL with
>the argc in a C program ?

Not that I know of, but you could default the values to 'NOARG' or some other value so that you could detect where they stop.

                                   Craig
Received on Tue May 18 1993 - 22:54:47 CEST

Original text of this message