putting parameters in one parameter....help!!

From: deb <dnanda_at_netcom.ca>
Date: Wed, 28 Apr 1999 19:29:32 -0400
Message-ID: <9bNV2.25790$134.294265@tor-nn1.netcom.ca>

hi ,
i have a problem ...i have a procedure which takes variable number of parameters and now the problem is that i need to put these incoming parameters into one variable. This one variable is then to be passed to a procedure which will then parse these parameters one by one... and break them up again to get the orginal set of inputs...i hope i am clear...here is my code

create or replace procedure main(argv in types.myarray) is
par_value_list varchar2(100);
begin
for i in..argv.count loop
if argv.count !=1 then
 /* i.e., the number of parameters is more than one, then...*/ par_value_list :='session_id='||argv(1)||';page_id='||argv(2)||; so on

---

in the above i just want to append session_id= to the value stored in argv(1) and do the same for the variables that follow.

An example would be: 2 variables being passed with the following values - argv(1)=10 and argv(2)=20, then the desired result is one text string containing--> 'session_id=10;page_id=20' Received on Wed Apr 28 1999 - 18:29:32 CDT