PL/SQL Tables (arrays)

I just constructed a package that contains two PL/SQL tables. I am developing with Oracles WebServer and what I am trying to do is pass an array from one procedure to the next. I can get the array loaded correctly but when I try to pass it to the next procedure but it crashes saying:

PLS-00306: wrong number or types of arguments in call to '||'

What I did was to pass the array thru a <form> similar to:

<FORM NAME = profs ACTION =
"http://........');
htp.print(' <INPUT TYPE = hidden NAME = p_emp_no VALUE = '||p_emp_no||'>

<input type = hidden name = "v_prof" value = '||v_prof||'>
<input type = hidden name = "w_prof" value = '||w_prof||'>
<INPUT TYPE = hidden NAME = p_discipline_id VALUE =
'||p_discipline_id||'>

</FORM>');

Where v_prof is the actual array. I think the problem is that v_prof on the NAME side is a single element field whereas the value is multiple. Any insite on how to get this array passed to another procedure??

thanks in advance..
kevin Received on Tue Jul 14 1998 - 09:32:59 CDT