Help, How can I pass ARRAY in PL/SQL procedure as a parameter

From: Divakar <kimmane_at_email.msn.com>
Date: Sat, 11 Apr 1998 12:04:33 -0400
Message-ID: <u4vmAMWZ9GA.211@uppubnews03>

Help .
Dos anyone know how to pass array as a parameter in PL/SQL. The requirement goes like this.
I am using Oracle web server 3.0. Where I have html form which has multile select box.what that means is that. List box shows n numbers of options and you can choose more than one. When you submit this form recieving procedure should have a parament which is array to hold this. sending procedure
htp.p('<form action="PK_CONTACT.SP_VALIDATE" method="POST">')

    htp.p('<tr><td align="right" valign="top">Operations/&nbsp;  <br>Coverage&nbsp;<br>Location(s):</td><td align="left" colspan="3">

     <select name="LocationList" multiple size="5">');    IF NOT location_csr%ISOPEN
   THEN
      OPEN location_csr;
   END IF;
   LOOP FETCH location_csr into location_rec;    IF location_csr%FOUND THEN
   l_location_loop_count := l_location_loop_count + 1;    IF l_location_loop_count >= 1 then

     l_location_cd := location_rec.location_cd;
     l_location_tx := location_rec.location_tx;
     htp.p('<option value='||'"'||l_location_cd||'">'||l_location_tx);   END

IF;

   END LOOP;
   htp.formSelectClose;
   htp.p('</tr>');
Recievin Procedure
 Procedure SP_VALIDATE

     LocationList IN varchar2 DEFAULT NULL, -- Multiple select
     Comments IN varchar2 DEFAULT NULL)  -- comments

   IS

Problem here is that when you select more that one item in the list, What datatype you use to hold this multiple values passed as parameter Thanks

Please help. Received on Sat Apr 11 1998 - 11:04:33 CDT