Tom,

Have you ever implemented multiple option select in pl/sql? I used to do it in php, which is quite straightforward: you take the choices and assign it to an array. I thought I should be able to do it in pl/sql too, using one of the collection types to take the list of values, so I tried the following:

create type multi_option_t as varray (10) of varchar2(1);
/

create or replace procedure test (multi_option IN multi_option_t default NULL,
p_submit IN varchar2 default NULL)
as
begin
if (p_submit = 'Submit') then
htp.p('foobar');
for i in 1 .. multi_option.count
loop
htp.p('value for the ' || i || 'th element is ' || multi_option(i));
end loop;
else
htp.p('<center><table width="98%"><tr>');
htp.p('<form method="post" action="test" name="testform">');
htp.p('<tr><td width="50%">Choose Status</td>');
htp.p(' <td width="50%">
<select name="multi_option" multiple>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</td></tr>');
htp.p('<tr><td colspan="2"><input type="submit" name="p_submit" value="Submit"></td></tr>');

htp.p('</table></form>');
end if;
end test;
/


But it did not do the trick. It compiled ok but at run time, error msg I got:
ORA-06550: line 7, column 2:
PLS-00306: wrong number or types of arguments in call to 'TEST'
ORA-06550: line 7, column 2:
PL/SQL: Statement ignored

PARAMETERS :
============
MULTI_OPTION:
2
P_SUBMIT:
Submit

The parameters for the varray always just show the 1st choice. Seems it is not recognizing multi_option as type multi_option_t at all - it is still treated as a scalar parameter. Is varray not the right type to use for this, or it is something else?

Thanks a million!