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

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 ?
Nope, there ain't. And this is not likely to change judging by the draft ansi sql3 spec, apart from as a mechanism for overloading a function name.

-- 
David T. Bath             | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
Senior Tech Consultant    | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
Global Technology Group   | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
"The robber of your free will does not exist" - Epictetus