PL/SQL subprogram arguments in numerical order
From: Piero Stanchi <stanchi_at_ariadne.it>
Date: 1996/05/10
Message-ID: <31931454.41C67EA6_at_ariadne.it>#1/1
Date: 1996/05/10
Message-ID: <31931454.41C67EA6_at_ariadne.it>#1/1
Hi everybody,
is there a way in pl/sql to access subprogram arguments in numerical
order (e.g. argv(1), argv(2),...)? Is the manual creation of a few
pl/sql tables (one for each argument type) the only way? Is there an
oracle table where the arguments of each stored subprogram may be
accessed (e.g. with something like:
for i in (
select ARG_NAME from all_procs where PROC_NAME = 'my_proc' ) loop
- print i.ARG_NAME end loop; )? -- Piero Dig Stanchi --- Ariadne S.r.l. E-mail: stanchi_at_ariadne.it Web: http://www.ariadne.it Phone&Fax: +39 382 407538/407225 Postal mail: Via Campeggi 13 - 27020 Casottole di Torre d'Isola (PV) - Italy