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>
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.
CraigReceived on Tue May 18 1993 - 22:54:47 CEST